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
6
votes
2 answers

How to keep leading zero and add comma in openoffice calc formula?

I have 6 fields in a row in open office, the 1st is a word, the 2nd, 3rd, and 4th are a number with a leading zero, the 5th and 6th are regular numbers. How do I join them all together with a comma between them so that the leading zero stays?
user1367204
  • 4,549
  • 10
  • 49
  • 78
5
votes
3 answers

Expanding a table of frequencies in Excel into a single column

I've read elsewhere on Stack Overflow that Excel questions are acceptable here, so please don't get annoyed :) If they should be elsewhere, just let me know... I'm frustrated, because I'm pretty sure I used to know how to do this. Imagine the…
Andrew
  • 1,157
  • 1
  • 20
  • 37
5
votes
1 answer

Merging data in Open/LibreOffice Calc

I have two sets of data in .csv format which share a field called sku. The second one has additional columns which need to be added to the first, but they have different sets of data, only some of which overlaps. The only data that needs to be…
Ivy
  • 3,393
  • 11
  • 33
  • 46
5
votes
2 answers

OpenOffice pyuno "select all"

Does anyone know how to use the OO uno bridge api to "select all" in a Calc sheet? Alternatively, finding the maximum used row and column number would work. What I want to do is apply a format to all the cells in the spreadsheet. (The reason being…
c-urchin
  • 4,344
  • 6
  • 28
  • 30
5
votes
2 answers

R Copy from Clipboard in Ubuntu Linux

I want to copy from the Ubuntu Linux clipboard into R Studio. My workflow consists of moving back and forth between R Studio and LibreOffice Calc. I've found the following code for writing to a Linux X11 clipboard, but I don't know how to read from…
stackinator
  • 5,429
  • 8
  • 43
  • 84
5
votes
1 answer

Search and replace regular expression in Open Office calc

I've got something like this (in Open Office Calc): Streetname. Number Streetname. Number a etc. Now I want to delete everything in front of the number. So I need to do a search and replace I guess. ^.*?([0-9]) this one matches Streetname.…
Chris8080
  • 53
  • 1
  • 1
  • 3
5
votes
3 answers

Convert Calc(Excel) Data in XML in OpenOffice

I have a requirement to convert OpenOffice Excel data into XML . I have Apache OpenOffice 4.1.1 in my machine (not MS- Office). Sample Data. (First Row is of Tags ) CustData FirstName MiddleName LastName EMail PhoneNumber …
Rohit
  • 172
  • 1
  • 9
5
votes
3 answers

Open Office Calc:Convert list of text urls into links

I have a list of text urls in, how i can convert all of them into clickable links?
Jask
  • 660
  • 10
  • 23
5
votes
3 answers

Openoffice - CSV-export: is there a default escape-charcter?

As far as I can see OpenOffice, when it comes to save a file as a csv-file, encloses all strings in quote-characters. So is there any need for an escape character? and related to this question: Does OpenOffice have a default escape character?
sid_com
  • 24,137
  • 26
  • 96
  • 187
5
votes
2 answers

Generate OpenOffice calc files using PHP

I have been trying to find a simple way to create OpenOffice calc files with no success. I have tried: openTBS - Seems to work writing an xml and a template file but can't find anything about how the xml file format. Ods php generator - I tried this…
Victor
  • 359
  • 1
  • 4
  • 15
5
votes
1 answer

LibreOffice Calc / OpenOffice Calc: How to filter rows based on their background color?

I'd like to filter out rows with a specific color on a specific column. I tried to search nearly everywhere but couldn't find my answer. Hope for some good advice, thanks.
prx
  • 59
  • 1
  • 1
  • 2
5
votes
1 answer

Row numbering selection auto-fill till the end

I have a table with thousands of lines. I want to number rows by adding 1 2 3 next to first rows, then to select these and drag till end to make a fill with increasing numbers. How to autofill till last row without dragging with a mouse for several…
user1841829
5
votes
1 answer

COUNTIF with multiple criteria

Can you please advise on how can I use COUNTIF with multiple conditions? My proposal (left) shows the formula for one criterion (distinct regions). However, I am interested in counting distinct regions for each distinct month (two criteria) - on…
Sam
  • 3,067
  • 19
  • 53
  • 55
5
votes
1 answer

highlight duplicate Value in Open Office org Calc

I am using OPEN OFFICE ORG CALC. I can't use MSOFFICE How can i highlight Duplicate value in a Column ? I am in real need. Did my part of homework LINK 1, Link 2
Prahalad Gaggar
  • 11,389
  • 16
  • 53
  • 71
5
votes
3 answers

Can python read the value of a cell in a spreadsheet?

All, Can python read the value of a cell in a spreadsheet? From a mapping/GIS/analysis standpoint: the simplest example would be a script that ran a buffer (proximity) tool on a given shapefile (GIS dataset). For the buffer distance parameter,…
DPSSpatial
  • 767
  • 3
  • 11
  • 31
1 2
3
39 40