When I saved a Calc spreadsheet in Excel format to send to my Accountant,
the SUMPRODUCT formulas did not work because a Calc formula like this:
=SUMPRODUCT(A1:A3000; B1:B3000)
was converted to :
=SUMPRODUCT(A1:A3000, B1:B3000)
ie semicolons ";" replaced with commas ","
but Excel wanted it in this format:
=SUMPRODUCT((A1:A3000)*( B1:B3000))
So, I replaced all the ";" with ")*(" and fixed up the other parentheses and
it worked!
I then did a bit of formatting on the Excel version and added a few recent
entries, before sending it off to my accountant. So that I had an
up-to-date Calc version I then opened my Excel spreadsheet with Calc and
everything worked! So I saved it as a Calc spreadsheet and the job was done.
I then looked at the Calc SUMPRODUCT formulas to see how Calc had converted
them from the Excel version and was surprised to find they had not been
changed at all ... i.e.
In the Excel spreadsheet the formula was:
=SUMPRODUCT((A1:A3000)*( B1:B3000))
and in the new Calc spreadsheet, the formula is:
=SUMPRODUCT((A1:A3000)*( B1:B3000))
and not
=SUMPRODUCT(A1:A3000; B1:B3000)
which is the Calc syntax
Why is this so?
Is it perhaps that OOo Calc has a hidden list of Excel formula formats so
that when Calc is presented with an Excel formula it knows how to execute
it?
If any of you know the answer, I would be obliged if you could share it with
me.
Many thanks, James
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
