[Libreoffice-bugs] [Bug 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

Gabor Kelemen  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #33 from Gabor Kelemen  ---
We checked this with recent versions, and it seems to be gone now. Cell styles
are now imported and exported mostly correctly.

In particular, the problematic commit in comment #11 was fixed in: 

https://cgit.freedesktop.org/libreoffice/core/commit/?id=1e68aabdeaacd8d4cac94d46925a55e2a93880d7

as a bit of bibisecting on bibisect-win32-6.1 has shown.

*** This bug has been marked as a duplicate of bug 98074 ***

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #32 from Rob  ---
Possibly related I too had xlsx files that the alignments rendered correctly in
Excel but wrong in LO if they originated from sources other than Excel.
i.e.
1. create xlsx in Excel, alignment all OK in both Excel and LO
2. create xlsx in non excel source, alignment OK in Excel, alignment wrong in
LO

It turned out [in my case] the styles.xml had a difference,
- those files created in Excel included: applyAlignment="true" in the elements
within the cellXfs section of styles.xml
- those files created outside Excel didn't include this item, (adding this
fixed the problem*.)

(* in my case the "outside Excel" source was from a package called EPPlus, I
patched my own copy to include the: applyAlignment="1" where necessary.)

Another way of looking at it:
Excel: styles default for applyAlignment is True (or 1) [ if allignment items
are present]
LibreOffice: styles default for applyAlignment is False (or 0) unless
explicitly set

so either:
(1) need to patch the originator of your xlsx files to include that
applyAlignment="1"/"True" item in the styles.xml,
or 
(2)patch LibreOffice to change it's default to True.

- In my case #1 was much easier.
- The LibreOffice maintainers would need to decide if #2 is an appropriate /
permanent fix and is so apply it.

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

Bartosz  changed:

   What|Removed |Added

 Status|ASSIGNED|NEW
   Assignee|gan...@poczta.onet.pl   |libreoffice-b...@lists.free
   ||desktop.org

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

Bartosz Kosiorek  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

Bartosz Kosiorek  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |gan...@poczta.onet.pl
   |desktop.org |

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #28 from Bartosz Kosiorek  ---
*** Bug 100347 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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #27 from Bartosz Kosiorek  ---
*** Bug 100464 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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #26 from Elmar  ---
Created attachment 125918
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125918=edit
saved by excel after error correction

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #25 from Elmar  ---
Created attachment 125917
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125917=edit
opened in excel with error error log

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #24 from Elmar  ---
Created attachment 125916
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125916=edit
created byc calc

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #23 from Elmar  ---
Created attachment 125915
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125915=edit
created by excel saved by calc

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #22 from Elmar  ---
Created attachment 125914
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125914=edit
created by excel saved by excel

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #21 from Elmar  ---
Created attachment 125913
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125913=edit
created by excel

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #20 from Elmar  ---
(In reply to Bartosz Kosiorek from comment #19)
> I would like to fix that issue.
> Could you please create .xlsx file with custom formatting via MS Excel and
> then open it with LibreOffice?
> After that save it into .xlsx format again, reopen and check if this issue
> is still there.
> 
> 
> I would like to compare two .xlsx files (correct one and incorrect). 
> It will dramatically help in resolving that issue.

done what you asked:
1. created "test1 created by excel.xlsx" using ms excel saved by ms excel
2. saved "test1a created by excel saved by calc.ods" saved by calc
3. saved "test1b created by excel saved by calc.xlsx" saved by excel
4. create "test2 created by calc.ods" using calc
5. on opening has error, see log file "test2 error015520_01.xml"
6. saved by excel as "test2a created by calc opened by excel saved by
excel.xlsx"

hope that 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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #19 from Bartosz Kosiorek  ---
I would like to fix that issue.
Could you please create .xlsx file with custom formatting via MS Excel and then
open it with LibreOffice?
After that save it into .xlsx format again, reopen and check if this issue is
still there.


I would like to compare two .xlsx files (correct one and incorrect). 
It will dramatically help in resolving that issue.

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #17 from Bartosz Kosiorek  ---
I would like to fix that issue.
Could you please create .xlsx file with custom formatting via MS Excel and then
open it with LibreOffice?
After that save it into .xlsx format again, reopen and check if this issue is
still there.


I would like to compare two .xlsx files (correct one and incorrect). 
It will dramatically help in resolving that issue.

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX ( Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #17 from Bartosz Kosiorek  ---
I would like to fix that issue.
Could you please create .xlsx file with custom formatting via MS Excel and then
open it with LibreOffice?
After that save it into .xlsx format again, reopen and check if this issue is
still there.


I would like to compare two .xlsx files (correct one and incorrect). 
It will dramatically help in resolving that issue.

--- Comment #18 from Bartosz Kosiorek  ---
I would like to fix that issue.
Could you please create .xlsx file with custom formatting via MS Excel and then
open it with LibreOffice?
After that save it into .xlsx format again, reopen and check if this issue is
still there.


I would like to compare two .xlsx files (correct one and incorrect). 
It will dramatically help in resolving that issue.

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #16 from Elmar  ---
(In reply to Ambrose Li from comment #15)
> This is still present in 5.0.5.2.
> 
> IMHO this is a serious problem, because the .xlsx file does not survive
> across a round trip from Excel to LibreOffice back to Excel, making
> LibreOffice useless when Excel is in the loop anywhere.

I agree. I have to do this all the time. My workaround is to save it to xls
(Excel 2003) and then if necessary to open that in Excel and then save it to
xlsx (Excel 2007 and later).

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

Ambrose Li  changed:

   What|Removed |Added

 CC||ambrose...@gmail.com

--- Comment #15 from Ambrose Li  ---
This is still present in 5.0.5.2.

IMHO this is a serious problem, because the .xlsx file does not survive across
a round trip from Excel to LibreOffice back to Excel, making LibreOffice
useless when Excel is in the loop anywhere.

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

--- Comment #14 from Buovjaga  ---
*** Bug 98672 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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

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

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

Matthew Francis fdb...@neosheffield.co.uk changed:

   What|Removed |Added

   Keywords||bisected
 CC||fdb...@neosheffield.co.uk
 Whiteboard|bibisectRequest |bibisected

--- Comment #11 from Matthew Francis fdb...@neosheffield.co.uk ---
Before the below commit, when saved as .xslx the styles come back as Excel
Built-in name with no hierarchy. After, they're absent.

I note also that at the start of 4.4 master, the same styles retain their
hierarchy when saved as .xls, but that's been broken since as well (a separate
bug - will investigate separately)


commit 1e68aabdeaacd8d4cac94d46925a55e2a93880d7
Author: Kohei Yoshida kohei.yosh...@collabora.com
AuthorDate: Tue Aug 12 17:10:40 2014 -0400
Commit: Kohei Yoshida kohei.yosh...@collabora.com
CommitDate: Tue Aug 12 22:05:36 2014 -0400

Don't export builtinId of 54 or above.

Change-Id: I5ab651e0c92ab032d892080f979aa4f53295a8b6

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

Matthew Francis fdb...@neosheffield.co.uk changed:

   What|Removed |Added

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

--- Comment #12 from Matthew Francis fdb...@neosheffield.co.uk ---
XLS style hierarchy issue mentioned in comment 11 - bug 93528

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

Timur gti...@gmail.com changed:

   What|Removed |Added

   Keywords||regression
 Whiteboard||bibisectRequest

-- 
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 93045] FILESAVE: custom styles lost on saving to XLSX (Summary in Comment 6)

[bugzilla-daemon]

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

Timur gti...@gmail.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||gti...@gmail.com
   Hardware|x86-64 (AMD64)  |All
Version|unspecified |4.4.0.0.beta1
Summary|FILESAVE|FILESAVE: custom styles
   ||lost on saving to XLSX
   ||(Summary in Comment 6)
 Ever confirmed|0   |1
 OS|Linux (All) |All

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