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
5
votes
1 answer

How to identify duplicate values in two columns in Openoffice Calc

I have two columns that have numbers in them. The other has the numbers only once, when the other has duplicates. The numbers in these columns don't match. I need to find all the numbers in column B that have a match in column A. This probably…
mmmajuri
  • 63
  • 1
  • 1
  • 4
4
votes
1 answer

PHPExcel OpenOffice Calc (ods) files issue

sorry for my english... I am trying implement phpexcel to read diferent type of files specifically .xls, .xlsx and .ods files. I am using this example for my tests With .xls files... all ok. with .xlsx files... all ok. but.. with .ods files, it's…
el_quick
  • 4,656
  • 11
  • 45
  • 53
4
votes
2 answers

Regex replace is eating up the whole string! How do I make regex ungreedy?

I'm working with a really large spreedsheet in Open Office and I've had to learn regular expressions to clean it up. Right now I'm trying to remove all tags and I've come up with an expression to do so: (|) The problem is…
user316602
4
votes
2 answers

Error with Roo . Any gems to parse .ods files

I am trying to use the roo gem to parse an Openoffice spreadsheet. However I am getting the following error while beginning my localhost /home/raison/.rvm/gems/ruby-1.9.2-p180/gems/roo-1.9.3/lib/roo/openoffice.rb:3:in `require': no such file to load…
rdsoze
  • 1,768
  • 1
  • 15
  • 25
4
votes
2 answers

How can I get a random cell in OpenOffice Calc?

I've perused the Stack Exchange list of sites, and I can only think that SO is the right place to ask this (I saw a few excel questions, at least). I have an array of values Sheet1.B3:B9. On another sheet, I'm trying to get a random value from one…
Stephen
  • 18,827
  • 9
  • 60
  • 98
4
votes
1 answer

Referencing the row below the current one in OpenOffice / LibreOffice Calc

In OpenOffice Calc / LibreOffice Calc, I need to find out if a cell in the row below the current cell is empty. To do this, I use the ISBLANK() function. For example, ISBLANK(B5) That works well, but I need the function to be generic to always look…
4
votes
2 answers

openoffice calc - newline causes duplicate value in cells (pandas/openpyxl)

Does anyone know how to workaround a problem of OpenOffice Calc not handling new lines in cells correct? I have a python script that is dynamically generating an excel workbook using openpyxl via pandas. The script works fine but when I view cells…
GuHuka
  • 43
  • 6
4
votes
1 answer

Libreoffice : Filtering with a list of value

I'm looking for a way to filter rows of a column with multiple values with LibreOffice/OpenOffice. For example, I have these texts cells : A B A D .... G G D H I I want to give a list of value (in cells) A G D ... to filter my data…
JeanJouX
  • 2,555
  • 1
  • 25
  • 37
4
votes
1 answer

How to delete duplicates, but keep the first instance and a blank cell for the duplicates in OpenOffice Calc?

If I have data like: A B C 111 asdews iujfhg 111 oikufjf jasddaf 112 eifjfjc olkdkj 112 eiejdj olokjjfki 112 ioeiurjf oleodks 113 oeiekdkd poldkkmd I would like to delete…
o_O
  • 5,527
  • 12
  • 52
  • 90
4
votes
1 answer

How to find duplicates values and keep only those rows?

I am checking an huge Open Office Calc list on multiple values in column C. I have a file like this A B C jan 1 Joop 35,90 jan 1 Kees 80,10 jan 2 Joep 79,99 jan 4 Kip 14,88 jan 4 Roel 15,66 jan 8 Riep …
Wiz
  • 59
  • 1
  • 1
  • 2
4
votes
1 answer

How can I speed up OpenOffice Calc Macro that updates many cells?

I have an OpenOffice Calc macro (in Basic) that rounds all numbers in the active worksheet to a given number of decimal places. It takes about 4 seconds to process 100 rows of a 9000 row spreadsheet. Each row has 35 columns, of which 19 columns are…
Paul Chernoch
  • 5,275
  • 3
  • 52
  • 73
3
votes
2 answers

Use Excel/OpenOffice cell names within drag-completition

I have a lot of measured values in each column. I use formulas under those values to calculate with them. I always edit the first column and drag-complete (small square in the south-east of the selected cell) to change the other columns, too. It was…
Lukas
  • 2,330
  • 2
  • 22
  • 31
3
votes
1 answer

Calculated in-document hyperlink

I would like to create a calculated hyperlink that will target a cell within the same document. Insert > Hyperlink allows this option and uses the string #Sheet1!A1, for the Cell A1 on Sheet1, for example. Is there a way to express this feature as a…
Miles
  • 33
  • 1
  • 3
3
votes
2 answers

Exporting a list to OpenOffice Calc from Delphi

I'm using Delphi 7 and I'd like to export the contents of a list from my program to OpenOffice Calc using automation, instead of using files. The task is simple: create new document, iterate through rows/columns and change cell data. I've found some…
Steve
  • 2,510
  • 4
  • 34
  • 53
3
votes
1 answer

Error while loading .ods sheet into Octave

I am trying to read a column of integers in a spreadsheet into Octave using the code A = odsread('Data.ods', 'Sheet1', 'A1:A946'); But it fails and I get a message with warnings and errors as : > unzip: cannot find or open Data.ods, Data.ods.zip…
Syed Saad
  • 705
  • 5
  • 15