[Libreoffice-bugs] [Bug 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WORKSFORME

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #14 from vlb  ---
(In reply to Buovjaga from comment #13)
> (In reply to vlb from comment #12)
> > I have test with the latest version LO 5.4.3.2 (x64)and isn't still present.
> 
> You mean the bug is gone?

Yes

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #13 from Buovjaga  ---
(In reply to vlb from comment #12)
> I have test with the latest version LO 5.4.3.2 (x64)and isn't still present.

You mean the bug is gone?

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #12 from vlb  ---
I have test with the latest version LO 5.4.3.2 (x64)and isn't still present.

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||thei...@seznam.cz

--- Comment #11 from m.a.riosv  ---
*** Bug 103609 has been marked as a duplicate of this bug. ***

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #10 from aerm...@gmail.com ---
Looked further into it. I tried this:
- Push F11 - Styles and Formatting
- Right click - New...
  - Name: GreenBackground
  - Background: Green
  - Save
- Enter "ab" in field A1
- Conditional Formatting: Condition on field A1
  - Cell value is equal to "ab"
  - Apply Style "GreenBackground"
  - OK
- Save as .xlsx file

When I open this file now in LibreOffice the conditional formatting is still
there. But when I push F11, the style "GreenBackground" is not there anymore.
There are 2 new styles: "ConditionalStyle_1" and "Excel Built-in Explanatory
Text". Both have the background set as green.

When I now change anything else (not related to the conditional formatting),
for exampe put 2 in field E3 and save (still as xlsx) and then open the file
again the green background in A1 is gone. Of the two new styles only
"ConditionalStyle_1" is left but without background color set.

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #9 from aerm...@gmail.com ---
I tested it with LibreOffice and Excel, this is what LibreOffice 5.1.3
produces:



abc





And this is what Excel 2016 produces:


"abc"



-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||aerm...@gmail.com

--- Comment #8 from m.a.riosv  ---
*** Bug 100237 has been marked as a duplicate of this bug. ***

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #7 from Buovjaga  ---
(In reply to vlb from comment #6)
> 1) open test file
> 2) open a new file
> 2) copy cell A1:A2 to the new file and save as *.ods
> 3) then save the new file as XSLX
> 4 ) when open in excel there is a error present

Repro.

Win 8.1 32-bit
MSO 2013
LibO Version: 5.3.0.0.alpha0+
Build ID: 9d2f7be4e65595241db3cf5135b69bd9e4ce6a30
CPU Threads: 4; OS Version: Windows 6.29; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-05-27_22:55:26
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #6 from vlb  ---
I have test in:
Version: 5.2.0.0.alpha1+
Build ID: 7b704dfbdb23540ff6366fa60c73474bbda9dc26
CPU Threads: 8; OS Version: Windows 6.19; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-05-20_05:45:40
Locale: nl-NL (nl_NL)

and LO 5.1.3.2

What i have found is next:
Reproduce:

1) open test file
2) open a new file
2) copy cell A1:A2 to the new file and save as *.ods
3) then save the new file as XSLX
4 ) when open in excel there is a error present

Not reproduce when:
1) open test file
2) copy A1:A2 and close the file
2) open a new file
2) paste to cell A1 in the new file and save as *.ods
3) then save the new file as XSLX
4 ) when open in excel there isn't a error present

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #5 from Markus Mohrhard  ---
It seems to work in my build and the only thing that seems different is that in
the attached test file the dxf record is not exported.

Can someone else reproduce it with a current daily build?

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 CC||er...@redhat.com,
   ||markus.mohrhard@googlemail.
   ||com
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=99
   ||917

--- Comment #4 from Eike Rathke  ---
@moggi: my guess, related to bug 99917 and the  element contains
something Excel doesn't like, i.e. attributes unrelated to expression?

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Attachment #125065|application/octet-stream|application/vnd.openxmlform
  mime type||ats-officedocument.spreadsh
   ||eetml.sheet

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

steve -_-  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=86
   ||575

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

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

--- Comment #3 from Buovjaga  ---
Repro.

Win 8.1 32-bit
LibreOffice Version: 5.2.0.0.alpha1+
Build ID: cc1a0ba927ad6f85103059aa8e6108017f436304
CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-05-17_02:31:19
Locale: fi-FI (fi_FI)
MSO 2013

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #2 from vlb  ---
Created attachment 125065
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125065=edit
saved xslx file

-- 
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 99866] EDITING: File save as xlsx Conditional formatting not saved in excel and give error

[bugzilla-daemon]

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

--- Comment #1 from vlb  ---
(In reply to vlb from comment #0)
> Created attachment 125064 [details]
> test file
> 
> windows 10 64 bits LO 5.1.3.2
> 
> Reproduce bug:
> 
> 1)open attachment
> 2) save as *.xslx
> 3) open in excel and give error and conditional formatting are disappeared
> in excel

Conditional formatting are in cell a1

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