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

Merging two mailing lists based on one column, and removing duplicates

I have a client who sends out a physical newsletter to tens of thousands of customers. They have one list of physical addresses, but every year they receive a new list from the company who runs their box office and they need to merge this list into…
-1
votes
1 answer

Calc/Spreadsheet: combine/assign/migrate cols

Sorry, i can't use the right terms but i try to explain my task: In Calc, or Spreadsheet I have two worksheets with columns like this: | ID| | 32| | 51| | 51| | 63| | 70| and | ID|Name | | 01|name1 | | 02|name2 | …
eapo
  • 1,053
  • 1
  • 19
  • 40
-1
votes
1 answer

Show more than nine numbers after decimal point

I am in a situation of dealing with numbers when there is need to display the numbers as is on the Excel sheet. Currently 37.6172080480001 is being displayed as 37.617208048. Seems like the sheet by default only displays nine digits after the…
pal4life
  • 3,210
  • 5
  • 36
  • 57
-1
votes
1 answer

Python "Hello World" for Libreoffice-calc and Openoffice-calc

There is a python-helloworld example for Libre/Openoffice-writer (which is included in Libreoffice 4.1.6.2: def HelloWorldWriter( ): """Prints the string 'Hello World(in Python)' into the current document""" #get the doc from the scripting…
Roland Seuhs
  • 1,878
  • 4
  • 27
  • 51
-1
votes
1 answer

CSV > Calc - Text to Date

I imported a CSV file into Calc. Unfortunately, formatting a text field as a date field in Calc leaves the leading '. I wrote the following function, but continue to get Error 508 - error in bracketing. I have re-bracketed a bunch of different ways,…
-1
votes
2 answers

Plotting number of times a name occurs in a column (histogram)

I have a list of names sorted, like below: ACVR2B ADAM19 ADAM29 ADAM29 ADAMTS1 ADAMTS1 ADAMTS1 ADAMTS12 ADAMTS16 ADAMTS16 ADAMTS16 ADAMTS17 ADAMTS17 ADAMTSL1 ADCY10 would like to plot them as a histogram. It is very easy when these are values but…
Angelo
  • 4,829
  • 7
  • 35
  • 56
-1
votes
1 answer

OpenOffice macro counter help please

I have a spreadsheet in OpenOffice that I need to add a macro into that basically just counts up to a certain number. I prefer to use Python as I am most familiar with it, but I have no experience with applying that to macros in OpenOffice. This…
SRQ
  • 7
  • 2
-1
votes
1 answer

OpenOffice Calc (Macros)

I am trying to make a Loop in OpenOffice Calc (Macros) I have tried this so far : Sub Main For x = 1 To 10 If Cells(x,1) = 50 Then Cells(x,1).Value = 20 End If End For End Sub Does any one know how it works ?
Amir009
  • 5
  • 1
-1
votes
1 answer

OpenOffice-Calc How to set a maximum value for a column

I'm trying to set the maximum number of a column to 50, so any number greater than 50 should show up as 50 in the spreadsheet. I'm not sure if using find and replace is the way to go. I can't seem to find a way to make find and replace look for…
-1
votes
1 answer

How to write a formula in calc so that the formula contains ref to a cell which in turn contains ref to a different cell?

Say I want to write a formula in 5 cells of column D (D1 to D5) based on a column which may vary. In other words, the second column can be B (B1 to B5) or C (C1 to C5) or any other columns. I don't know. But i need the results in column D (D1 to…
-1
votes
1 answer

removing duplicate based two coulmn value.

I need a help from you guys. my data is like this A A value 1 value 2 A B value# value# B A value# value# D F value# value# V F value# value# i need either of one row either A B or B A.it should look like this A A value 1 value 2 A B value#…
user1586957
  • 149
  • 2
  • 13
-1
votes
1 answer

Average over a column if text in another column maches

I want to compute the average over one column if the text in another column matches a certain text. eg: A B C aa 6 =AVERAGEIF(B1:B6;EXACT(A1:A6;"aa")) bb 15 aa 8 bb 17 cc 1 aa 5 But the value in C…
thedarkside ofthemoon
  • 2,251
  • 6
  • 31
  • 48
-1
votes
1 answer

How to export a table into the open office spreadsheet (.ods file) through C#.net?

I want to create a .ods file throught C#.net and also want to export tables,images into it. Is there any solution for that?
tejaswini
  • 1
  • 2
-1
votes
1 answer

How to insert column of cells from one sheet to a single cell of another sheet in OpenOffice?

I have a sheet 'MODELS' with columns of data, each column varies in how many cells (rows). I'm wanting to paste a column from this sheet into another sheet 'COMBINED' into a single cell. For my first cell in COMBINED, I tried using…
-1
votes
1 answer

java based calculation engine based on Open Office Calc

The requirement is to build a calculation engine which is performant and supports excel like formulas. These formulas need to be applied on huge data sets (millions of rows of data). I was thinking if something could be built on top of OpenOffice…
Sathya
  • 2,371
  • 5
  • 19
  • 27