https://issues.apache.org/ooo/show_bug.cgi?id=120863
Priority: P3
Bug ID: 120863
Assignee: [email protected]
Summary: Importing Excel 2000 XLS file, sheet name inserted in
conditional-format equations
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.0
Component: open-import
Product: spreadsheet
Created attachment 79364
--> https://issues.apache.org/ooo/attachment.cgi?id=79364&action=edit
XLS file with conditional format equations, C6:D7
When importing an XLS file created by Excel 2000, and I have a conditional
format equation like:
=AND(E6<$B6,COUNT(E6))
what I see in OO/Calc 3.4.0 is
AND('2013'.E6<'2013'.$B6;COUNT('2013'.E6))
which is technically correct (2013 is the name of the sheet), but ugly. It'd be
nice if it didn't insert the sheet name.
And I have seen, but can't reproduce now, an actual corruption of the cell
coordinates at times, so instead of E6, it'd show A1, and even sometimes A65xxx
(~ 2^16-1). I was tracking down something else at the time so didn't pay
attention to that issue, and now I can't get it to do that again.
I'm using Vista, and somebody on the forums tried it on Linux, and OO/Calc did
the same thing (added in the sheet name).
--
You are receiving this mail because:
You are the assignee for the bug.
