Bug 94254 - FILESAVE: XLSX - Data table text and fill style not retained [RT]
Summary: FILESAVE: XLSX - Data table text and fill style not retained [RT]
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: OOXML-Chart
  Show dependency treegraph
 
Reported: 2015-09-16 04:38 UTC by Yousuf Philips (jay) (retired)
Modified: 2022-09-15 20:32 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Before and After (62.14 KB, image/png)
2015-09-16 04:38 UTC, Yousuf Philips (jay) (retired)
Details
Screenshot of the example file and its Calc-saved version side by side in Excel and Calc (97.01 KB, image/png)
2020-10-02 06:21 UTC, NISZ LibreOffice Team
Details
The original and its Calc-saved version in Excel (106.42 KB, image/png)
2022-09-15 20:31 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2015-09-16 04:38:59 UTC
Created attachment 118757 [details]
Before and After

Steps:
1) Open attachment 114697 [details]
2) Save and close
3) Reopen file in MSO

You will notice that the data table borders is black (0,0,0) rather than gray (217,217,217) and the text color is black (0,0,0) rather than dark gray (89,89,89).

Version: 5.1.0.0.alpha1+
Build ID: 88c51cd55d1a9b29e62269c53b3923770253ab07
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-09-11_13:09:15
Locale: en-US (en_US)
Comment 1 Buovjaga 2015-10-10 12:43:42 UTC
Repro.

Win 8.1 32-bit
MSO 2013
LibO Version: 5.0.3.1
Build ID: fd8cfc22f7f58033351fcb8a83b92acbadb0749e
Locale: fi-FI (fi_FI)
Comment 2 QA Administrators 2016-11-08 11:30:46 UTC Comment hidden (obsolete)
Comment 3 Buovjaga 2020-10-01 10:16:21 UTC
Still repro with MSO 2013

Version: 7.1.0.0.alpha0+ (x86)
Build ID: dda71436b8594fb0669b3ac06c02a3997a0674be
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded
Comment 4 hkathleenc 2020-10-01 22:07:23 UTC
This bug is no longer reproducible in:

Version: 7.0.1.2 (x64)
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

Changing status to RESOLVED WORKSFORME
Comment 5 NISZ LibreOffice Team 2020-10-02 06:21:29 UTC
Created attachment 166016 [details]
Screenshot of the example file and its Calc-saved version side by side in Excel and Calc

In current nightly the line color still changes on export:

Version: 7.1.0.0.alpha0+ (x64)
Build ID: dda71436b8594fb0669b3ac06c02a3997a0674be
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL
Comment 6 NISZ LibreOffice Team 2020-10-02 06:21:52 UTC
Back to NEW.
Comment 7 Gabor Kelemen (allotropia) 2022-09-15 20:31:43 UTC
Created attachment 182475 [details]
The original and its Calc-saved version in Excel

This seems to be fixed now in 7.5 since

https://git.libreoffice.org/core/+/89c7f5c5a8898ee2dcb0c738e8ce026e5b238ea5

author	Tomaž Vajngerl <tomaz.vajngerl@collabora.co.uk>	Mon May 23 15:50:59 2022 +0900
committer	Tomaž Vajngerl <quikee@gmail.com>	Thu Jul 28 18:16:07 2022 +0200

oox export: export line/fill and text props. of a data table
Comment 8 Gabor Kelemen (allotropia) 2022-09-15 20:32:36 UTC
Thanks Tomaž for the work here :)