[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

Markus Mohrhard  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |markus.mohrhard@googlemail.
   |desktop.org |com

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

--- Comment #13 from Markus Mohrhard  ---
This seems to be related to a bug in the OOXML specification.

§18.3.1.10 says for the operator attribute: "The operator in a "cell value is"
conditional formatting rule. This attribute is ignored if
type is not equal to cellIs"

but checking §18.18.15 there are at least 4 attribute values that are not
related to cellIs. I have added them now but need to test that this really
helps.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

Beluga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||todven...@suomi24.fi
 Ever confirmed|0   |1

--- Comment #12 from Beluga  ---
(In reply to Duncan from comment #7)
> Created attachment 122435 [details]
> Conditional formatting example saved with LibreOffice
> 
> Opening this in MS Excel does not show any conditional formatting

Opening this in LibO shows the colors. It has named the styles to
ConditionalStyle_X
I tried saving it to ods in Libo and then to xlsx. Now the colors were not
shown in LibO.
I tried doing a simple condition from scratch (if contains "a", change style to
Heading). Saving as .xlsx and opening in LibO, it doesn't show the heading
formatting (again a ConditionalStyle_1 was created).

Confirmed that MSO doesn't show the formatting either.

It seems something went worse after attachment 122435 was created, as now even
LibO doesn't preserve the formatting in a way that it would understand.

Let's keep this one open for now.

Win 8.1 32-bit
MSO 2013
Version: 5.2.0.0.alpha0+
Build ID: a6f876d45bd4e41a7143594a6cb11b6893a0f620
CPU Threads: 4; OS Version: Windows 6.29; UI Render: GL; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-11_00:07:38
Locale: fi-FI (fi_FI)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

--- Comment #11 from Duncan  ---
Possibly related to #65371

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

--- Comment #10 from Duncan  ---
I checked inside the save files to see what differences there are in the way
the conditional formatting is saved. Here is the result:
http://pastebin.com/D5Xksmj2

The excel version is from both 2007 and 2010 versions, I was unable to test
with a less messed up version of MSO because I dont have access to one

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

Duncan  changed:

   What|Removed |Added

 Status|RESOLVED|UNCONFIRMED
Version|3.4.3 release   |5.0.1.2 release
 Resolution|INVALID |---
 Ever confirmed|1   |0
 OS|Linux (All) |Windows (All)

--- Comment #6 from Duncan  ---
I am having an issue which matches this description. I have changed the version
and hardware to refelct my system. For reference the original report was in
3.4.3 on linux.

I will redescribe the issue:
When saving a document in xlsx (office open version) format with conditional
formatting that changes the style of cells based on their text content
(contains string), then opening the document in MS Excel (tested with 2007 and
2010), the conditional formatting is not shown.

If the user creates conditional formatting in msxl and opens it in calc the
formatting is shown correctly. If the user changes anything on this page in
calc and then saves, then opens again in msxl the formatting is gone again.

In the msxl conditional formatting 'manage rules' menu all the rules are
present as normal, but none of them are working. If the edit rule screen is
opened for each rule and then closed again with the 'ok' button (no actual
changes necessary), the formatting reappears and shows correctly.

Saving in msxl and opening in calc does not result in any issue.

This feels like a microsoft bug to me but if it is then I am out of luck so
here's hoping.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

--- Comment #8 from Duncan  ---
Created attachment 122436
  --> https://bugs.documentfoundation.org/attachment.cgi?id=122436=edit
Conditional formatting example saved with MS Office

Opening this in either office program shows the formatting correctly

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

--- Comment #7 from Duncan  ---
Created attachment 122435
  --> https://bugs.documentfoundation.org/attachment.cgi?id=122435=edit
Conditional formatting example saved with LibreOffice

Opening this in MS Excel does not show any conditional formatting

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=41722

--- Comment #9 from Duncan  ---
I updated to the newest stable (5.0.4.2 (x64)) and was still able to reproduce
the issue as described

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=41722

Florian Reisinger reisi...@gmail.com changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution||INVALID
 CC||reisi...@gmail.com

--- Comment #2 from Florian Reisinger reisi...@gmail.com 2012-08-14 14:00:21 
UTC ---
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within
the last six months, we close all of these bugs.

To keep this message short, more infos are available @
https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is
prepared for developers to fix your problem.

Yours!

Florian

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=41722

--- Comment #3 from Florian Reisinger reisi...@gmail.com 2012-08-14 14:01:28 
UTC ---
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within
the last six months, we close all of these bugs.

To keep this message short, more infos are available @
https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is
prepared for developers to fix your problem.

Yours!

Florian

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=41722

--- Comment #5 from Florian Reisinger reisi...@gmail.com 2012-08-14 14:08:13 
UTC ---
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within
the last six months, we close all of these bugs.

To keep this message short, more infos are available @
https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is
prepared for developers to fix your problem.

Yours!

Florian

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=41722

--- Comment #4 from Florian Reisinger reisi...@gmail.com 2012-08-14 14:06:12 
UTC ---
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within
the last six months, we close all of these bugs.

To keep this message short, more infos are available @
https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is
prepared for developers to fix your problem.

Yours!

Florian

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=41722

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from Björn Michaelsen bjoern.michael...@canonical.com 
2011-12-23 12:40:50 PST ---
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2
prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation:
http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 41722] conditional formatting does not export to excel

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=41722

David Tse d...@lsijax.com changed:

   What|Removed |Added

   Platform|Other   |x86-64 (AMD64)
 OS/Version|All |Linux (All)
 CC||d...@lsijax.com

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs