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...
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
XLS file with conditional format equations, C6:D7 (15.50 KB, application/vnd.ms-excel)
2012-09-10 04:08 UTC, Paul Kinzelman 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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:
             =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).
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

Regars 

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 4.0.2.2 - 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.

Regars

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

Regars.

Yurggent Alfredo