https://bugs.freedesktop.org/show_bug.cgi?id=66985
Priority: medium
Bug ID: 66985
Assignee: [email protected]
Summary: ill-handling of numbers in imported xls worksheet
Severity: critical
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 3.6.0.4 release
Component: Spreadsheet
Product: LibreOffice
I have seen for long that when any xls worksheet is opened,the numbers,dates,(
even text starting with a number in a cell) are imported with an 'apostrophe'
behind them.So,the cell content is not treated as number any more.This gives
rise to a nightmarish prospect when working with a xls file in OO / LO. To be
able to do any mathematical operation on the content is impossible without
first removing the apostrophe in the cell individually.
Is it because MSO has any invisible apostrophes in the cells starting with a
numeral ? I cannot say. But if so, OO / LO should remove such an apostrophe.
OR is this apostrophe added by OO / LO ? I do not see any reason for doing that
and crippling usefulness of it's import. Eitherway, it is a bug in LO / OO
and this is a major bug. This severely limits the very usefulness of the import
facility.
I have seen descriptions of tricks to removing the apostrophe, but they are
obviously hacks. Why should LO not be able to treat dates and numbers correctly
when importing ?
I have seen numerous discussions on the Net on this topic. But I have not seen
this referenced as a Bug. If this is a duplicate bug, kindly mark so, but
remove this bug,please on priority.
--
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
