Bug 165754 - Cell border formatting suddenly doesn't save in xlsx between sessions
Summary: Cell border formatting suddenly doesn't save in xlsx between sessions
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks: Cell-Border
  Show dependency tree / graph
 
Reported: 2025-03-15 09:27 UTC by Ivan
Modified: 2025-10-07 20:33 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ivan 2025-03-15 09:27:02 UTC 
Description:
In LibreOffice Calc 25.2 When editing borders (changing thickness from default to 1,5) the changes apply as expected. After saving, closing and re-opening the document, the changes in formatting vanish for no reason. The bug appeared suddenly and persists throughout differet existing and newly-created files. Changing borders from non-formatted to 0,75 (default thickness) does persist and function as expected. Same applies to thicker borders than 1,5. ODS format seems unaffected by the problem.  

Steps to Reproduce:
1. Create or open an .xlsx spreadsheet
2. Format cell borders to regular line, thickness 1,5
3. Save the document
4. Open document again

Actual Results:
All 1,5 thick borders revert to usual 0,75 thickness. Borders that are thicker than 1,5 remain unaffected.

Expected Results:
Any formatting to cell borders should apply and persist between sessions (opening the file later)


Reproducible: Always


User Profile Reset: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: ru
Module: SpreadsheetDocument
LibreOffice is installed through Flatpak
[Information guessed from browser]
OS: Linux (ALT Linux Regular Gnome)
OS is 64bit: yes
Comment 1 raal 2025-03-15 12:53:55 UTC 
Confirm with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ddaea18557b1ec60d9e360f9eab539c8f551061f
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

Works in Version: 7.3.7.2
Comment 2 BogdanB 2025-08-25 14:49:45 UTC 
Also in 24.2
Comment 3 Buovjaga 2025-10-07 20:33:19 UTC 
(In reply to raal from comment #1)
> Works in Version: 7.3.7.2

Result does not seem correct, I repro from scratch in both oldest and master of linux-64-7.3

Bibisected with win32-4.3 to 8d140f3867221979bf19b4a7a50f2bb1d6908038
More faithful mapping of border line thicknesses.

I did it from scratch in the UI as using an existing .ods file and command line conversion seemed to produce unreliable results.

Reverting 8d140f3867221979bf19b4a7a50f2bb1d6908038 indeed keeps the rendering thick. It's actually rendered a bit thicker in an opened XLSX file than when you have just applied the thickness.