Bug 140185 - XLSX file doesn't save border padding for styles
Summary: XLSX file doesn't save border padding for styles
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: DOCX-Limitations
  Show dependency treegraph
 
Reported: 2021-02-05 12:03 UTC by BogdanB
Modified: 2022-09-21 18:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
the test document (7.69 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-02-05 12:04 UTC, BogdanB
Details
video (2.35 MB, video/mp4)
2021-02-05 19:39 UTC, BogdanB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description BogdanB 2021-02-05 12:03:39 UTC
Description:
Style A, Style B and Style C are 3 styles in this document with a padding border of 2 mm.
After closing the file and reopening the padding is the default, not the saved one.

Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded

Steps to Reproduce:
See above

Actual Results:
Style A, B and C have  a padding of 0.35 mm

Expected Results:
Style A, B and C have  a padding of 2 mm, as it was saved before closing the file


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded
Comment 1 BogdanB 2021-02-05 12:04:13 UTC
Created attachment 169497 [details]
the test document
Comment 2 BogdanB 2021-02-05 12:45:43 UTC
Doesn't repro when saved as .odf.
Comment 3 BogdanB 2021-02-05 12:47:40 UTC
Steps to reproduce:
- Open the file, be sure that Style A, or B, or C have padding of 2 mm. Save the file
- reopen and check styles. The padding is 0.35 mm. Should be 2 mm.
Comment 4 BogdanB 2021-02-05 19:38:54 UTC
Repro also on linux

Version: 7.1.0.3 / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: en-US (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 5 BogdanB 2021-02-05 19:39:14 UTC
Created attachment 169514 [details]
video

video showing the bug
Comment 6 Buovjaga 2021-03-18 17:27:22 UTC
(In reply to BogdanB from comment #3)
> Steps to reproduce:
> - Open the file, be sure that Style A, or B, or C have padding of 2 mm. Save
> the file
> - reopen and check styles. The padding is 0.35 mm. Should be 2 mm.

The styles already have 0.35 mm padding upon opening for me. I changed one of the styles to have 2 mm padding and it didn't stay after save & reload. But why do we have different initial values?

Arch Linux 64-bit
Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 48570b9b5e4939069f8a1a2541fd4efe6f2bb0aa
CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 18 March 2021
Comment 7 BogdanB 2021-03-25 08:12:00 UTC
In the video the unit was points, and we use mm as unit. This is the differences.
Comment 8 BogdanB 2021-04-21 17:16:05 UTC
Retested with
Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 93bb5fcba9e58eeeaaed9521c3bb4eecf9b91ac1
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

The same loosing of padding for the style in the xlsx file.
Comment 9 BogdanB 2021-05-18 10:23:56 UTC
Retested on Windows. Repro
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 6c8ca02c5935a800cff70f3c173319b454b63c41
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded
Comment 10 BogdanB 2021-07-14 10:18:46 UTC
Retested on
Version: 7.2.0.1.0+ (x64) / LibreOffice Community
Build ID: ffeeb78118a887419c5f33bb5311f0e2ddae463c
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded

I hoped some changes in code meanwhile could solve this bug.
Comment 11 Buovjaga 2021-08-10 19:00:29 UTC
Already seen in oldest of 6.3 repo. Latest of 50max repo drops the styles completely.
Comment 12 BogdanB 2022-01-21 01:59:59 UTC
Retested on 7.3. The same.
Version: 7.3.1.0.0+ / LibreOffice Community
Build ID: 216ad305810d1d36cf5874fd9842111d426899a8
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 13 BogdanB 2022-05-07 03:56:07 UTC
The same.
Retested on Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 08c979e235aa993f50e54224f8c715bb70697c33
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 14 BogdanB 2022-08-11 05:23:42 UTC
This are the comments from the dbg version when reproducing the bug

warn:stoc:4055:4055:stoc/source/javaloader/javaloader.cxx:381: getJavaVM returned null
warn:sfx.dialog:4055:4055:sfx2/source/dialog/filtergrouping.cxx:359: already have an element for WordPerfect
warn:sfx.dialog:4055:4055:sfx2/source/dialog/filtergrouping.cxx:359: already have an element for writerweb8_writer_template
warn:sfx.dialog:4055:4055:sfx2/source/dialog/filtergrouping.cxx:359: already have an element for writerglobal8
warn:xmloff:4055:4055:sax/source/fastparser/fastparser.cxx:1324: unknown element xsi:type http://www.w3.org/2001/XMLSchema-instance
warn:xmloff:4055:4055:sax/source/fastparser/fastparser.cxx:1324: unknown element xsi:type http://www.w3.org/2001/XMLSchema-instance
warn:svx:4055:4055:svx/source/unodraw/unoshape.cxx:1795: DBG_UNHANDLED_EXCEPTION in setPropertyValues exception: com.sun.star.beans.UnknownPropertyException message: "GraphicColorMode at /home/tdf/lode/jenkins/workspace/lo_gerrit/tb/src_master/svx/source/unodraw/unoshape.cxx:1599"
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 25917
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26189
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26190
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 25917
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26189
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26190
warn:legacy.tools:4055:4055:svx/source/form/fmvwimp.cxx:437: FmXFormView::~FmXFormView: Window list not empty!
warn:sfx.appl:4055:4055:sfx2/source/appl/appserv.cxx:311: no parent for dialogs
warn:vcl.unx.print:4055:4055:vcl/unx/generic/printer/ppdparser.cxx:845: no Resolution in /tmp/00fd762f8d291
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x7e0 with unknown name, so returning lang-tag of: Spanish (Equatorial Guinea) {es-GQ}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x7e1 with unknown name, so returning lang-tag of: Spanish (Philippines) {es-PH}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:legacy.tools:4055:4055:svx/source/form/fmvwimp.cxx:437: FmXFormView::~FmXFormView: Window list not empty!
warn:legacy.tools:4055:4055:svx/source/form/fmvwimp.cxx:437: FmXFormView::~FmXFormView: Window list not empty!
warn:xmloff:4055:4055:sax/source/fastparser/fastparser.cxx:1324: unknown element xsi:type http://www.w3.org/2001/XMLSchema-instance
warn:xmloff:4055:4055:sax/source/fastparser/fastparser.cxx:1324: unknown element xsi:type http://www.w3.org/2001/XMLSchema-instance
warn:svx:4055:4055:svx/source/unodraw/unoshape.cxx:1795: DBG_UNHANDLED_EXCEPTION in setPropertyValues exception: com.sun.star.beans.UnknownPropertyException message: "GraphicColorMode at /home/tdf/lode/jenkins/workspace/lo_gerrit/tb/src_master/svx/source/unodraw/unoshape.cxx:1599"
warn:legacy.tools:4055:4055:svx/source/form/fmvwimp.cxx:437: FmXFormView::~FmXFormView: Window list not empty!
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 25917
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26189
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26190
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 25917
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26189
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26190
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:vcl.schedule:4055:4055:vcl/source/app/scheduler.cxx:603: Stop the task before changing the priority, as it will just change after the task was scheduled with the old prio!
warn:legacy.tools:4055:4055:svx/source/form/fmvwimp.cxx:437: FmXFormView::~FmXFormView: Window list not empty!
warn:sfx.appl:4055:4055:sfx2/source/appl/appserv.cxx:311: no parent for dialogs
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:sfx.appl:4055:4055:sfx2/source/appl/appserv.cxx:311: no parent for dialogs
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:legacy.tools:4055:4055:svx/source/form/fmvwimp.cxx:437: FmXFormView::~FmXFormView: Window list not empty!
warn:xmloff:4055:4055:sax/source/fastparser/fastparser.cxx:1324: unknown element xsi:type http://www.w3.org/2001/XMLSchema-instance
warn:xmloff:4055:4055:sax/source/fastparser/fastparser.cxx:1324: unknown element xsi:type http://www.w3.org/2001/XMLSchema-instance
warn:svx:4055:4055:svx/source/unodraw/unoshape.cxx:1795: DBG_UNHANDLED_EXCEPTION in setPropertyValues exception: com.sun.star.beans.UnknownPropertyException message: "GraphicColorMode at /home/tdf/lode/jenkins/workspace/lo_gerrit/tb/src_master/svx/source/unodraw/unoshape.cxx:1599"
warn:legacy.tools:4055:4055:svx/source/form/fmvwimp.cxx:437: FmXFormView::~FmXFormView: Window list not empty!
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:legacy.osl:4055:4055:sc/source/ui/view/tabvwshh.cxx:232: no accessibility broadcaster?
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 25917
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26189
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26190
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 25917
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26189
warn:sfx.control:4055:4055:sfx2/source/control/dispatch.cxx:1206: Childwindow slot missing: 26190
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:vcl.schedule:4055:4055:vcl/source/app/scheduler.cxx:603: Stop the task before changing the priority, as it will just change after the task was scheduled with the old prio!
warn:legacy.tools:4055:4055:svx/source/form/fmvwimp.cxx:437: FmXFormView::~FmXFormView: Window list not empty!
warn:sfx.appl:4055:4055:sfx2/source/appl/appserv.cxx:311: no parent for dialogs
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0x540a with unknown name, so returning lang-tag of: Spanish (United States) {es-US}
warn:svtools.misc:4055:4055:svtools/source/misc/langtab.cxx:240: Language: 0xe40a with unknown name, so returning lang-tag of: Spanish {es}
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
warn:svl.items:4055:4055:svl/source/items/itempool.cxx:442: old secondary pool: EditEngineItemPool of pool: XOutdevItemPool must be empty.
Comment 15 Justin L 2022-09-21 01:06:10 UTC
Saving as XLS has a similar problem, except that it likes 0.71mm instead.
Comment 16 Justin L 2022-09-21 01:35:36 UTC
Do MS formats allow for specifying the border spacing? I don't see any evidence of that in Excel 2003.
Comment 17 Justin L 2022-09-21 18:35:56 UTC
Internet searches indicate this is can only be done for columns, via "indent" options for left/right/distributed (up to 15pt). [This doesn't seem to be mapping to anything in LO, but there are lots of bug reports and the indenting amount is very in-exact.]

Apparently nothing exists for height (except centring and specifying a row height).

https://www.addintools.com/documents/excel/where-is-cell-padding/where-is-cell-padding.html

Marking as INVALID - request is for something not possible in MSO formats.