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

How to add cells across an unknown number of multiple spreadsheets?

In a spreadsheet, Sheet0 is the first and farthest left sheet in a series of tabs and is a summary of all worksheets to its right. Adding cells from multiple sheets is easy enough when the sheets are known, but is it possible to add, for example,…
user658182
  • 2,148
  • 5
  • 21
  • 36
-2
votes
2 answers

Manipulate .ods (OpenOffice) file by using c#

We have one existing ODS file (Open office spreadsheet) comprise of multiple sheets. I am intending to read the data from each sheet on want to update some cells on each sheet using c# I have googled a lot but not able to find any perfect…
Milind
  • 17
  • 4
-2
votes
1 answer

Excel Format NOW()

I know nothing about Excel (technically I'm using "Calc" in Open Office). I'm trying to set up a cell to auto-update with a date/time stamp if another cell has data entered into it with this code... =IF(AND(D14<>"";D14<>0);format(NOW(), "mmm. dd,…
gtilflm
  • 1,389
  • 1
  • 21
  • 51
-2
votes
1 answer

Show Image when column is clicked in excel which is saved in another sheet

I want to store some data in a row related to particular image and Image want to store in different sheet but in main sheet I want one column and when I click on this column then it will open the image. This will save the space and all the data will…
Vinit ...
  • 1,409
  • 10
  • 37
  • 66
-2
votes
1 answer

Extract part of array

I want to extract some part of array. Last six elements and first three. How can I do that in Excel and OpenOffice Calc? Array that I have: 04:52 08:48 04:59 08:48 05:50 00:00 00:00 I need #1: 08:48 04:59 08:48 05:50 00:00 …
user3082220
  • 169
  • 1
  • 2
  • 6
-2
votes
2 answers

Convert text cells to DATE, but leave empty and DATE cells intact

sorry for my ignorance I have no idea about spreadsheets. What I have is a column that contains dates but they are there in different format some are text like '19.12.2006 and others are cells that are formated as a date like 2009-10-10 I want them…
Seb
  • 113
  • 1
  • 4
  • 12
-2
votes
1 answer

Why is data repeated in Open Office Calc

I opened a .xlsx file in open office calc (on my mac) and the data in most of the cells which has numbered list items, is repeated twice. For example, if a particular cell has numbered list like: 1. something 2. something 3. something Then this…
Rahul Dole
  • 2,723
  • 2
  • 24
  • 30
-3
votes
2 answers

Replace everything after last slash in URL

I want to use a regex to do a search/replace in an open office spreadsheet. I need to insert an authentication component in a list of urls right after the last forward slash. I tried [/]$ and (\/)$ with no luck. Example input: …
-3
votes
1 answer

How to sort columns alphabetically in a database table?

I know this issue could be taken as a basic question, but I don´t ask it in the 'classic' way, so I don't want to know how to sort elements that are into a column. I have a table in which I need to sort alphabetically the first row (column names),…
anxoestevez
  • 190
  • 2
  • 18
-4
votes
1 answer

MS OFFICE excel vs Open office Calc vs libreoffice calc and same formula not working on each why Any suggestions

Please help me on MS OFFICE excel Open office Calc libreoffice calc and the same formula is not working on each. Why same Copy paste and formula not working on each others.
-4
votes
1 answer

Apache Openoffice Calc Programming

I am a novice to programming using VBA with Microsoft. My organization has now adopted Apache Openoffice Suite as their productivity software. I have researched several websites seeking information for programming in Oo but am overwhelmed if not…
Streub
  • 1
  • 1
1 2 3
39
40