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
8
votes
10 answers

Change case of first letter in every cell in spreadsheet

I have many cells which I'd like to convert such that the first letter in every cell is capitalized. E.g. cook, chef, fireman becomes Cook, Chef, Fireman. I have the spreadsheet in OpenOffice.org, but it seems to only have options for "all…
Village
  • 22,513
  • 46
  • 122
  • 163
8
votes
1 answer

OpenOffice Python macros: Where can I find useful documentation?

I'm trying to make a macro for OpenOffice Calc that will toggle the background color of cells containing a user-specified value. Since I don't know OpenOffice Basic and have no desire to learn it, I'd like to write my macro in Python. The trouble…
Scott Severance
  • 943
  • 10
  • 27
8
votes
4 answers

Concatenate a range of cells in OO Calc

I have column A with these cells: A1: Apple A2: Banana A3: Cherry I want a formula that will string them together in one cell like this: "Apple, Banana, Cherry"
Tony H
  • 337
  • 2
  • 9
8
votes
2 answers

Count specific character in a cell in openoffice calc

I have a cell with some text content. For example: "Red, shirt, size," I need to count how many times the comma is used in this cell. The result should be "3" Any ideas?
SiteRefresh
  • 83
  • 1
  • 3
8
votes
1 answer

Cell content inside formula

Is it possible to place the content of a cell inside a formula. By formula I mean the math formula editor (insert->object->formula).
sauerburger
  • 4,569
  • 4
  • 31
  • 42
8
votes
6 answers

extract number from cell in openoffice calc

I have a column in open office like this: abc-23 abc-32 abc-1 Now, I need to get only the sum of the numbers 23, 32 and 1 using a formula and regular expressions in calc. How do I do that? I tried =SUMIF(F7:F16,"([:digit:].)$") But somehow this…
Vinay
  • 470
  • 1
  • 5
  • 18
8
votes
1 answer

Inserting Sheets in Spreadsheet through c#

I have created a a project that reads different files and puts then in different sheets with a spreadsheet. I have used Open office calc spreadsheet therefore used the following code to open a blank file: public XSpreadsheet getSpreadsheet(int…
Matt_Johndon
  • 204
  • 1
  • 6
  • 15
7
votes
2 answers

Formula to return random string from list of strings?

I want to display random courses (MBA, MSc) in OpenOffice Calc. I tried: =RANDBETWEEN('MBA', 'MSc') and =RAND('MBA', 'MSc')` but they don't work as desired.
Tamil Selvan C
  • 19,913
  • 12
  • 49
  • 70
7
votes
1 answer

Importing HTML table into OO Calc as UTF8 without converting to entities

I have a problem when opening a HTML table in OpenOffice or LibreOffice if it contains UTF8 extended characters like ÅÄÖåäö. When opening the table into M$ Excel it works as intended but I can't make OO do the same thing. By converting all extended…
6
votes
3 answers

Reading Openoffice Calc (.ods) programmatically using c#?

I want to know if it is possible to read OpenOffice Calc spreadsheet programatically with c#, I can do this for Excel(.xls and .xlsx) but unable to find a solution for reading calc spreadsheet. Help me if anyone has solution.
bharath ayyagari
  • 61
  • 1
  • 1
  • 2
6
votes
4 answers

Writing/Reading arrays of Data in Open Office using Python. Anyone have any example code?

So I have written a class that makes it extremely easy to interface with either Excel or Gnumeric using Python, and would like to extend the class to include Open Office as well. I could do this in 30 minutes if I just had the ability to do the…
Garrett Berg
  • 2,585
  • 1
  • 22
  • 21
6
votes
3 answers

How to set cell-color according to cell-value on ooo-calc?

I can change the style of a cell using conditional formatting. But there I would be limited to a maximum of 3 cases it can handle. What I want to do is to get the value of a cell, convert it in a certain way and set the result as the cells…
Simon
  • 4,395
  • 8
  • 33
  • 50
6
votes
1 answer

OpenOffice when exporting CSV underscores are replaced with "+AF8-"

I'm having issues with a Open Office. I'm trying to export some files as CSV text and it appears that underscores and perhaps some other characters are being replaced. For instance, I created this file in a text editor and saved it as…
Kevin K
  • 2,191
  • 2
  • 28
  • 41
6
votes
3 answers

Change #N/A to Blank cell

How can I change the #N/A to the blank cell if nothing in that cell? Eg. =VLOOKUP(B19:B36;$TABLE.A1:C46;2;0) I think I might need something like an ISERROR check but I don't 100% know what I'm doing.
user3440968
  • 61
  • 1
  • 1
  • 2
6
votes
1 answer

Delete duplicate rows in calc?

I have a column in openoffice calc with a set of codes. For example: B1 B1 Br Bh Ht C3 C3 So what I would like to do is delete all the duplicates so I am left with just: Br Bh Ht Any help much appreciated. Cheers
user2120088
  • 79
  • 1
  • 8
1
2
3
39 40