[Libreoffice-bugs] [Bug 40530] FILEOPEN MS Excel docmuent: 2nd condition for Conditional formatting missing

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Wed Aug 31 23:37:00 PDT 2011


Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:

           What    |Removed                     |Added
            Summary|Conditional formatting      |FILEOPEN MS Excel docmuent:
                   |problem when file created   |2nd condition for
                   |in MS Excel                 |Conditional formatting
                   |                            |missing
            Version|LibO 3.4.2 release          |LibO 3.3.3 release
  Status Whiteboard|                            |CONFIRMED
         AssignedTo|libreoffice-bugs at lists.free |kohei.yoshida at gmail.com
                   |desktop.org                 |
                 CC|                            |LibreOffice at bielefeldundbus
                   |                            |s.de

--- Comment #1 from Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> 2011-08-31 23:36:59 PDT ---
[Reproducible] with "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German
UI [OOO340m1 (Build:302)]" and reporter's sample document.

'D6' should have 2 conditions:
 1) If value bigger than 'C6' then show format "Excel_CondFormat_1_2_1"
 2) If value smaller than 'C6' then show format "Excel_CondFormat_1_1_1"(?)

In sample document only condition 1 is visible 
If you change value in D6 to 2000 you see that Condition 1 works

D6 is red opening sample document with MS EXCEL Viewer and EXCEL 2010, so those
programs recognize second condition and it seems not to be a damaged document

Still reproducible with server installation of Master "LibO-dev 3.5.0 – WIN7
Home Premium (64bit) English UI [(Build ID: a6adae1-4eb4f62-09af278)]"

None of the .xls file type selections heals the problem

Also a problem with LibO 3.3.3 Portable and OOo 3.1.1, so problem seems to be
inherited from OOo.

No problem when I save an own document with 2 conditions as .xls

Please feel free to reassign (or reset Assignee to default) if it’s not your
area or if provided information is not sufficient. Please set Status to
ASSIGNED if you accept this Bug.

Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

More information about the Libreoffice-bugs mailing list