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

Blank columns after each filled column in csv

I am getting blank column after each filled column in openoffice 3.3. In my PHP code I have provided ~~ as the seperator and \n as the delimiter I am using this PHP code header("Content-type: application/csv"); …
-1
votes
2 answers

Changing a spreadsheet formula so it works with PHP

for years now I have used a math formula to determine relative activity levels for message boards. Now I would like to use that formula in a php search engine to replace the non-functioning Google Page Ranking system. The data items used are:…
Rick
  • 1
-1
votes
1 answer

How to Filter out Duplicate rows(By a specific column) in Excel or Open Office CALC ??

I want to filter out rows in Excel/Open Office CALC like this : Here is My Table Structure Emp_No and Note Added are the column names Emp_no. Note added 10 salary due by 13th Oct 10 …
-1
votes
2 answers

Register database using a macro

I am trying to register a new database in OpenOffice Calc, but I need to make it using a script (macro). Is there any way to do it? If not, can I work on unregistered database in my Calc macros? If yes, how to do it? I am porting my VBA macro to…
Ziker
  • 141
  • 4
  • 20
-1
votes
1 answer

Stop truncation/rounding off

In OpenOffice Calc (spreadsheet) when I copy and paste a content in the cell it gets rounded off with three decimal places and the values get truncated with 000 in the end. e.g. If I paste 9104984638383554567 the value gets converted to…
user2377245
  • 37
  • 1
  • 1
  • 4
-1
votes
1 answer

Inserting values in libreoffice / excel without using autofill

I have a libreoffice sheet that I would like to have the rows increase by 1 example: 1 2 3 4 The problem is I know I can do this with autofill but I have 50000 rows and dragging down takes awhile. Thanks
Rick T
  • 3,349
  • 10
  • 54
  • 119
-1
votes
2 answers

how to: list all possible permutations of two columns of text in Openoffice Calc or Excel

I'm trying to do the following: I have a sheet with 2 columns of cells with text input. Now, I would like to generate all permutations, and preferably paste them in a separate sheet. Is there anyone who knows how to do this? (And who has some spare…
user2087584
-1
votes
1 answer

Spreadsheet: If row in sheet contains 2 criteria then get value of cell

Sheet 1 gets values from Sheet 2. Sheet 2 has hundreds of rows, but only 4 columns. (Cols A & C are names, Cols B & D are numbers). Cell XX (sheet 1): Looks in Sheet 2, For "Bill" (col A) and "Jill" (col C) where they BOTH appear in the same row,…
-1
votes
2 answers

Excel trick: pasting an entire column

I have a list of postal codes. I want to paste them into Excel in such a way that they appear all in one column (which is not the first column). Can this be done? If so than in what format should the postal codes be so that they are pasted…
user1527429
  • 727
  • 5
  • 10
  • 17
-1
votes
1 answer

Referring to adjacent cells in OpenOffice.org BASIC

I'm trying to calculate F-scores (using the formula 2 * a * b / (a + b)) in OpenOffice.org Calc, and would like a and b to be the previous two cells in the same row. My problem is that while trying to define a function in OpenOffice.org Basic, I get…
Jory
  • 155
  • 6
-1
votes
1 answer

why does OpenOffice Calc interpret "0411 08:55" as "411:08:55" in CSV file and what to do about it?

I guess the question says it all. My app outputs a plain text CSV file with month/date shown without separating character. This is plainly visible in Notepad. I even tried putting quotes around it for clarity. Calc, instead of showing what is…
EndangeringSpecies
  • 1,564
  • 1
  • 17
  • 39
-2
votes
1 answer

How to execute open office cal (macro) in asp.net core application

I am developing asp.net core application that downloads some excel files and executing macro on it. Macro is performing some data validation and data formatting and generating new excel file. I need to save this file in a specific folder on the…
-2
votes
1 answer

Connect R and Excel

I want to connect Excel and R. I have done a visualisation in R and the data was taken from excel. Now what i want to do is, the input and output should be on excel itself. So for the input, the screen on the excel will be a table and the user has…
S.snehu
  • 9
  • 6
-2
votes
3 answers

Spreadsheet - Conditional formatting cells based on other cells

Conditional formatting a cell is simple enough. It's also simple enough to conditionally format a single cell based on another single cell. What I'm not sure about is doing it for many cells in such a way that I don't have to format each individual…
-2
votes
3 answers

Execute a sub Function on a button which is created programatically

im rather new to VBA. MY problem is: I create a Button when I Click another Button: the create Button is created as followed: Set t = ActiveSheet.Range(Cells(i +6, 4), Cells(i+6, 5)) '+6 to start at cell 6 Set buttons = …
1 2 3
39
40