https://bugs.documentfoundation.org/show_bug.cgi?id=92256
Bug ID: 92256
Summary: INDIRECT function lost interoperabilty with calc
documents migrated by OOo3.2.1
Product: LibreOffice
Version: 4.4.2.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 116733
--> https://bugs.documentfoundation.org/attachment.cgi?id=116733&action=edit
example document showing that indirect ranges with excel syntax are no longer
supported
The attached document contains 3 examples for the indirect function.
1) the first is a very simple reference: =indirect("A1")
2) the second is a reference to a cell in another sheet in excel-syntax:
=indirect("Table2!A1")
3) the third is a reference to a cell in another sheet in calc-syntax:
=indirect("Table2.A1")
All these examples were successfully evaluated by OOo 3.2.1. Look at the
attached screenshot to see how OOo 3.2.1 behaves.
In LO up to 4.4 (I guess 5.0 and master, too), only two of these function are
evaluated correctly. The result depends on the current setting of the option
"tools->options->calc/formular/Formular-syntax". Look at the attached
screenshot to see how LO 4.4 behaves.
If it is set to "Calc A1" (which is the default), then 1) and 3) are correct
but 2) is not.
If it is set to "Excel A1", then 1) and 2) are correct, but 3) is not.
This simple behaviour change may lead our customer (city of munich) to serious
problems with calc documents:
There is a big amount of excel documents that were migrated with the help of
OOo 3.2.1 to ODS. They might use the indirect-function with excel strings (like
in 2). On the other side, OOo 3.2.1 is already in use since a bunch of years,
so there could be a lot of new documents created, that use the calc syntax
(like in 3). We need to ensure that ALL documents will work with LibreOffice -
old ones and new ones.
I know, that this seems to be very late for such a regression report, but the
issue is brand new and did not show up before. On most PC's in munich there is
still OOo3.2.1 used and the update to LibreOffice (here 4.1) is still in
progress.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
