Questions tagged [openoffice-calc]

related to OpenOffice.org Calc, a spreadsheet application which is similar to Microsoft Excel.

Calc is the spreadsheet application you've always wanted. Newcomers find it intuitive and easy to learn; professional data miners and number crunchers will appreciate the comprehensive range of advanced functions.

DataPilot is an advanced technology that makes it easy to pull in raw data from corporate databases; cross-tabulate, summarize, and convert it into meaningful information.

Natural language formulas let you create formulas using words (e.g. "sales - costs").

Intelligent Sum Button inserts a sum function or a subtotal automatically, depending on context.

Wizards guides you through choosing and using a comprehensive range of advanced spreadsheet functions, or download templates from our Templates repository for ready-made spreadsheet solutions.

Styles and Formatting makes it easy to apply flexible cell formatting options, including freely rotating contents, templates, backgrounds, borders, and many more. You can be your own spreadsheet expert thanks to templates with built-in functions, allowing you to concentrate on your real work.

Scenario Manager allows "what if ..." analysis at the touch of a button - e.g. compare profitability for high / medium / low sales forecasts.

Calc's solver component allows solving optimization problems where the optimum value of a particular spreadsheet cell has to be calculated based on constraints provided in other cells.

Multiple users support - Encourage collaborative work on spreadsheets. By sharing a spreadsheet, other users can easily add their data to the spreadsheet. The spreadsheet owner can then easily integrate the new data with a few clicks. This collaboration feature helps avoid editing conflicts.

Save your spreadsheets in OpenDocument format, the new international standard for office documents. This XML based format means you're not tied in to Calc. You can access your spreadsheets from any OpenDocument compliant software.

You are free to import your old Microsoft Excel spreadsheets, or save your work in Excel format for sending to people who are using Microsoft products. Calc is able to read .xlsx files created with Microsoft Office 2007 or Microsoft Office 2008 for Mac OS X.

If you want to send your results to someone who doesn't have a spreadsheet application installed, then use Portable Document Format (.pdf) - no need to buy or install any extra software.

596 questions
114
votes
5 answers

How to quote a quote with the CONCATENATE function in OOCalc

In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A. So in cell B1 I want to do: =CONCATENATE("\"",A1,"\"") OOCalc does not like this, or without the escaping backslash. Does anyone know how to do this, or…
Richard H
  • 38,037
  • 37
  • 111
  • 138
47
votes
8 answers

How to prevent OpenOffice/LibreOffice Calc from changing what you input (data, numbers,...)

Basically, I want LibreOffice Calc to do what I tell it, not what it wants. For example: when I input 1.1.12, I want to have 1.1.12 in that cell, not 01.01.2012 or whatever. when I input 001, I want to have 001 in that cell, not 1 and so on and…
Istrebitel
  • 2,963
  • 6
  • 34
  • 49
36
votes
5 answers

Libreoffice/Openoffice Calc - append string to cells

I need to add .jpg at the end of all he cells in one or more columns 9788895249971 into > 9788895249971.jpg 9788867230129 into > 9788867230129.jpg 9788867230273 into > 9788867230273.jpg 9788867230280 into > 9788867230280.jpg Detailed…
Gabriele
  • 503
  • 1
  • 5
  • 9
34
votes
1 answer

OOo/LibreOffice UNO / Java: How to get calling spreadsheet cell of a calc function?

In an UNO extension for OpenOffice/LibreOffice Calc (Spreadsheet), written in Java, how can you determine the calling cell inside the implementation of a UDF (spreadsheet function)? Remarks In Excel/VBA this is possible via Application.Caller The…
Christian Fries
  • 16,175
  • 10
  • 56
  • 67
30
votes
3 answers

Join two spreadsheets on a common column in Excel or OpenOffice

I have two CSV files with a common column and I want to "Join" the tables together on the common column. For example: Join 'A' with 'B' equals 'Result'. If a one table has a key value that does not exist on in the other table its just left as…
Steven Smethurst
  • 4,495
  • 15
  • 55
  • 92
21
votes
3 answers

Highlight duplicate values

In Excel, Office 2007, I have the option to highlight duplicate values on the menu. Keep simple! Select the column, select "Conditional Formatting" - "Highlight Cells Rules" - "Duplicate Values" and voilá! All values that were duplicate on this…
Edgar Oliveira
  • 323
  • 1
  • 2
  • 8
21
votes
2 answers

How to add number of days to a date, consider only business days (i.e. ignore weekends)?

I'm trying to create a formula to calculate the n-th Business Date (only Monday to Friday are business days). For simplicity's sake, holidays are not important; only weekends should be ignored. For example: …
E.Z.
  • 6,393
  • 11
  • 42
  • 69
16
votes
2 answers

How do I concatenate cells and add extra text?

I'm very new to Calc but a relative veteran with Excel. Unfortunately I don't have the latter available to me. I'm attempting to create a new cell inline with the data I need to use like the below AF Afghanistan AL Albania DZ Algeria with…
David Barker
  • 14,484
  • 3
  • 48
  • 77
16
votes
2 answers

How to merge two columns in open office calc

I have two column in open office calc. I want to merge then like following name last name fullname john carter name last name fullname john carter john carter How to do this?
Mukesh
  • 7,630
  • 21
  • 105
  • 159
14
votes
3 answers

Exporting CSV properly open Office (save numbers as TEXT)

I am using OPEN-OFFICE to work and save CSV. I am using the comma delimiter and ' " ' also. However, when saving the CSV, all numbers are not encapasulated. How can I force Open-Office to treat numbers as a Text and have them encapsulated too. …
user1023021
  • 343
  • 4
  • 8
  • 13
10
votes
2 answers

How can I call a Python macro in a cell formula in OpenOffice.Org Calc?

To extend OpenOffice's capabilities, I've defined some Python macros in a file in the user script directory (~/Library/Application Support/OpenOffice.org/3/user/Scripts/python/, in my case). The macros are visible in the Python macro organizer.…
outis
  • 75,655
  • 22
  • 151
  • 221
10
votes
2 answers

Convert spreadsheet decimal number format: period- and comma-separated decimal positions

In OpenOffice Calc, one can change number format between standard United States, with decimal separator being a period ., and the SI (International System) format with decimal separator being a comma ,. This can be done by setting the language to…
Gene Arboit
  • 183
  • 1
  • 1
  • 11
9
votes
1 answer

How to split a single word separated by space form single column into two columns

I am having the following records in column A Column A 4.0K 0000000.png 4.0K 0004.png 32K 00(1).gif 16K 001.gif My need is to split the size and name of the image in two different columns. That is Column A Column B 4.0K 0000000.png 4.0K…
Fero
  • 12,969
  • 46
  • 116
  • 157
9
votes
3 answers

Applying a formula to all cells in a column, not just one at a time?

In OpenOffice.org Calc, I would like to apply a formula to a column that references a cell from the same row but in a different column. I.e., =C1*48 in cell D1, but I want all cells in column D to do this without having to copy the formula to each…
rjray
  • 5,525
  • 4
  • 31
  • 37
9
votes
3 answers

Python, OpenOffice: Programmatically Manipulating spreadsheets

I have an spreadsheet-based automated report that needs to be created daily, with some charts, aggregating functions (e.g. SUM and AVERAGE) and formatted cells (Dates, percentage, etc.). I have tried to write these results directly to an Excel file,…
Adam Matan
  • 128,757
  • 147
  • 397
  • 562
1
2 3
39 40