incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 120863] New: Importing Excel 2000 XLS file, sheet name inserted in conditional-format equations
Date Mon, 10 Sep 2012 04:08:51 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=120863

          Priority: P3
            Bug ID: 120863
          Assignee: ooo-issues@incubator.apache.org
           Summary: Importing Excel 2000 XLS file, sheet name inserted in
                    conditional-format equations
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: All
          Reporter: paul@kinzelman.com
          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.

Mime
View raw message