Excel Spreadsheet vs Apache Calc
Posted: Sat Apr 27, 2019 6:40 pm
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
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