Page 1 of 1

Excel Spreadsheet vs Apache Calc

PostPosted: Sat Apr 27, 2019 6:40 pm
by RonWil
I am fairly conversant with Excel Spreadsheets and I am in the process of converting most of my Calc Files to Apache Calc.

In Excel, I have a spreadsheet which has multi number of sheets. On sheet 1, which I have named PAB, i can back-refer to this sheet to pick up data on to sheet 2 etc. The way I can do this is to enter, in sheet 2 at the appropriate location. =PAB!B13 and this copies the data on Sheet PAB at Location B13 into sheet 2 and, if required, sheet 3 and so on.

Can you please let me know what the equivalent command is in Apache Calc?

Thanks Ron Wilson

Re: Excel Spreadsheet vs Apache Calc

PostPosted: Sat Apr 27, 2019 7:35 pm
by RusselB
With the main exception of any macro codes, most of your Excel spreadsheets will open in OpenOffice Calc without problem.
Some of the formulas may (or will) change to match the entry method used by OpenOffice Calc. Example: Using ; instead of , as parameter separators.
In the case you have specified, there will be a small change, specifically the ! will change to a .

Again, you (probably) won't have to make many (if any) changes if you just open your Excel spreadsheet in OpenOffice Calc.
You might want to consider using LibreOffice, rather than OpenOffice, as it has a higher compatibility level with MS Office and is updated more frequently than OpenOffice.

Re: Excel Spreadsheet vs Apache Calc

PostPosted: Sat Apr 27, 2019 9:03 pm
by Villeroy
Install https://libreoffice.org/ for a modern variant of OpenOffice which is more similar to Excel.