Hi,
When I open the same spreadsheet in LibreOffice versions 7.6.7.2 and 25.8.2.2, I see this formatting difference in column L. Does anyone know how to fix it so that the formatting in version 25.8.2.2 is the same as in version 7.6.7.2?
Version 7.6.7.2:
Captura de tela 2025-11-06 1327241366×720 109 KB
Version 25.8.2.2:
Hello,
.xlsx. Always somehow problematic.Images tell next to nothing about causes.
Guess: A whitespace character which is used as the separator between text parts in a single cell is interpreted in one case as a kind of tabulator but is interpreted in the other case as NewLine.
To get closer THE FILE IS NEEDED.
You must use one column for the subjects and other for the values.
But it works the way it is in LibreOffice version 7.6.7.2.
As supposed (at least partly):
The horizontal tabulating the space behind the “line titles” ending with a colon inside the cell seems to be arranged misusing the character U+0001 which is one of the old control characters:
U+0001 1 001 [Start of Heading](https://en.wikipedia.org/wiki/C0_and_C1_control_codes) SOH / Ctrl-A
LibreOffice doesn’t support this kind of tabulating inside cells.
If it once did, it was a mistake mimicking MS nonsense “for compatibility” purposes.
I don’t know enough about xlsx to study the file structure.
The NewLine functionality inside cells is coded with U+000A as it also is done in Calc.
You may report a “bug” asking for the reinstatement of the older behavior.
This reduced file doesn’t contain a single spreadsheet formula.
If there are no additional sheets containing formulas, Calc is simply the wrong tool for what you want to achieve.
What about a column width of nearly 50 cm?
Even at this width there is a lot of overflow to adjacent colums.
If you want to keep your data this way: Create a text document, copy the sheet, and use Paste Special with RTF to get the sheet as a TextTable. In a text table tabulators are supported. (Insertion with Ctrl+Tab.)