Issue 120863 - Importing Excel 2000 XLS file, sheet name inserted in conditional-format equations
Summary: Importing Excel 2000 XLS file, sheet name inserted in conditional-format equa...
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-09-10 04:08 UTC by Paul Kinzelman
Modified: 2013-05-03 20:24 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

XLS file with conditional format equations, C6:D7 (15.50 KB, application/
2012-09-10 04:08 UTC, Paul Kinzelman
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Paul Kinzelman 2012-09-10 04:08:51 UTC
Created attachment 79364 [details]
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:
what I see in OO/Calc 3.4.0 is
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).
Comment 1 Yurggent Alfredo Chable Torrez 2013-05-03 18:48:20 UTC
Hello Paul Kinzelman,

I just checked the problem you describe, and my imported file does not put the sheet name in the format equation.

I have tested this with Windows 7 and AOO 4.0.0


Yurggent Alfredo
Comment 2 Paul Kinzelman 2013-05-03 19:44:52 UTC
Hi Yurggent! Thanks for looking at this.

Are you sure you tried *conditional* format? I just retried it and it's still broken (works on Excel 2000).

I'm using Vista and Calc - just downloaded.
I still get the page number in the conditional format formula as I described
in the original post.
Comment 3 Yurggent Alfredo Chable Torrez 2013-05-03 20:20:07 UTC
Hi Paul Kinzelman

excuse me for my mistake, it is true, in the formula includes the name of the style sheet.

now i will change the status.


Yurggent Alfredo.
Comment 4 Yurggent Alfredo Chable Torrez 2013-05-03 20:24:14 UTC
this happend with a conditional format equations when you import from excel to  calc. 
it's a bug.

this was checked it in Windows 7 with AOO 4.0.0


Yurggent Alfredo