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
Created attachment 169497 [details] the test document
Doesn't repro when saved as .odf.
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.
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
Created attachment 169514 [details] video video showing the bug
(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
In the video the unit was points, and we use mm as unit. This is the differences.
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.
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
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.
Already seen in oldest of 6.3 repo. Latest of 50max repo drops the styles completely.
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
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
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.
Saving as XLS has a similar problem, except that it likes 0.71mm instead.
Do MS formats allow for specifying the border spacing? I don't see any evidence of that in Excel 2003.
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.
Same in libreoffice-3.3.0 for XLSX
*** Bug 157447 has been marked as a duplicate of this bug. ***
*** Bug 158959 has been marked as a duplicate of this bug. ***