https://bugs.freedesktop.org/show_bug.cgi?id=57076
Priority: medium
Bug ID: 57076
Assignee: [email protected]
Summary: Import of XLS of conditional formatting in FILEOPEN
prepends the sheet name to cell names
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 3.6.1.2 release
Component: Spreadsheet
Product: LibreOffice
If I have an XLS file created in Excel, and a cell has a Conditional Format
formula like:
=AND(D6<$B6,COUNT(D6))
and I import it into Calc, what I see instead is:
AND('2012'.D6<'2012'.$B6,COUNT('2012'.D6))
where '2012' is the name of the sheet.
The formula is arithmetically correct, but it's got extra stuff in there which
I don't want to see.
The import should import exactly what the formula is and should not add any
embellishment.
This bug has been in a number of versions, and even in openoffice.
--
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
