https://bugs.documentfoundation.org/show_bug.cgi?id=89330
Bug ID: 89330
Summary: Cell formula converted to lowercase, including
cross-references to other files when having a syntax
error
Product: LibreOffice
Version: 4.3.6.1 rc
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jfe...@gmail.com
On version 4.3.6.2 as found in F21.
Build ID: 4.3.6.2-1.fc21
When entering in a cell a formula including a reference to cells in another
file, if the formula has a syntax error, the complete content of the formula is
converted to lowercase, including the path to the file containing the
referenced cells.
That is a problem on case sensitive operating systems, such as Linux, and
should not happen, at least not on file path components of a formula.
To reproduce:
- open two sheets, from two different files FileA and FileB,
- from sheet FileA, enter a valid reference to a cell in FileB,
- the path is shown in the formula with the valid case,
- modify the formula to introduce an error, such as an invalid cell reference
(='file:///Path/To/FileA.ods'#$Sheet1.A1A instead of
='file:///Path/To/FileA.ods'#$Sheet1.A1),
- the complete content of the formula is converted to lower case:
='file:///path/to/filea.ods'#$sheet1.a1a
Which makes it even more difficult to fix the formula, as usually you to
rebuild it completely if the path is long...
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
