Hi Niklas,
Niklas Nebel schrieb:
On 04/14/10 22:44, Regina Henschel wrote:
Of cause we have to consider the effort for a particular solution. But
blaming MS does not delete those documents. We need an agreement, what
Calc should do with those Excel-ods documents.
When loading the file, we import the formulas the same way as for xslx
files. It's even the same code that's used, and it's easy to determine
the type of formula from the namespace. There doesn't seem to be much
disagreement about this part.
The problem is, that Excel 2010 has a lot of _new_ functions. Therefore
the user gets a lot of #NAME? errors. He can see in the input line, what
formula causes this error, but the bad thing is, that the user is not
able to see the value, that has been calculated in Excel.
When saving, we would have to know if the file is meant to be opened in
Excel. In the end, it would boil down to choosing a different file
format. But then, you can just save as xls if you want to open a file
with Excel.
No, you cannot use xls, because the functions are not available in xls.
To make it clearer. Up to Excel 2007 there are only small problems. Most
major functions have a counterpart in the other application. But with
Excel 2010 we get more than 50 new functions. A lot of them can be
mapped to Calc function. But there are at least AGGREGATE, CONFIDENCE.T,
CEILING.PRECISE, F.DIST, MODE.MULT and NETWORKSDAYS.INTL (I have not yet
examined all the others) where a simple mapping is impossible.
You wrote:
"When saving, we would have to know if the file is meant to be opened in
Excel. In the end, it would boil down to choosing a different file
format."
That would be the choice C of my initial posting?
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
