https://bugs.freedesktop.org/show_bug.cgi?id=77570
Priority: medium
Bug ID: 77570
Assignee: [email protected]
Summary: FILTER: Strange things happens converting an excel
file with a FIND() function...
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 97504
--> https://bugs.freedesktop.org/attachment.cgi?id=97504&action=edit
The file with the bug
We are in progress migrating some PC from XP/MSO2003 to Win7/LO4.1, and
converting a (set of) file we have faces a strange things, that seems really a
bug.
The attached ODS file was converted barely from excel (opened, then save as)
and apart some cosmetic change seems to work well. On the third sheet (I
intermedia) the strange happen.
In cell 17-20/A-D there's 4 FIND() formula, and two of them return erroneous
value in respect to excel.
After fiddling a bit, i've found the if i simply copy the FORMULA TEXT (not the
cell, but the formula; or, the same, i retype it) the correct output appear.
You can see in the attachment column F that have the same formula but the
correct result.
Seems to me that the import filter imported correctly the ''external
representation'' of the formula, but wrongly import the ''internal'' one.
I'm seeking feedback. Thanks.
PS: i've opened the file also on Ubuntu, LO version 1.4.3.2 and depicted the
same bug.
Operating System: Windows 7
Version: 4.1.1.2 release
--
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
