Bug 130383 - Text in a column disapear after reload the .ods
Summary: Text in a column disapear after reload the .ods
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected
Depends on:
Reported: 2020-02-03 11:49 UTC by Philgood
Modified: 2020-09-19 11:43 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

See line 5 only C14 is visible, but contain others valus not printable (20.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-02-03 11:51 UTC, Philgood
Bibisect log (3.06 KB, text/plain)
2020-05-03 21:12 UTC, Telesto

Note You need to log in before you can comment on or make changes to this bug.
Description Philgood 2020-02-03 11:49:08 UTC
Before saving the .ods, line 5, the column is C2, C4, C5, C6, C7, C8, C9, C11, C12, C13, C14. The text C2 to C13 is at the 1st line and C14 at the 2nd line of the cell.
After reload, only appear (and printed) C14
But, in the same column, but line 24 the same case with R9, R12, R14, R15, R16, R21, R23, R27, R32, R34  and no problem after reload, the 2 line of the column are visibles and printable.
Alignement of the cells is in French: Renvoi à la ligne et coupure des mots.

Actual Results:
A 7.7Cm width column and text is C2, C4, C5, C6, C7, C8, C9, C11, C12, C13, C14
Save the sheet quit programm, reload the sheet, only C14 is visible and printable

Expected Results:
C2, C4, C5, C6, C7, C8, C9, C11, C12, C13,
In the same cell

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Philgood 2020-02-03 11:51:27 UTC
Created attachment 157616 [details]
See line 5 only C14 is visible, but contain others valus not printable

Line 5 is KO but, the line 24 is OK.. Why ? it is the same case ?
Comment 2 m.a.riosv 2020-02-03 21:23:11 UTC
I can't repro.
Version: (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 4; OS: Windows 10.0 Build 19555; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
Comment 3 Buovjaga 2020-05-02 17:08:03 UTC
Ok, so looking at cell F5, it only displays "C14" when viewed on Linux, but on Windows it displays the actual contents "C2, C4, C5, C6, C7, C8, C9, C11, C12, C13, C14"

Weird that the bug was reported against Windows, though.

This is not yet seen with latest commit of Linux 50max bibisect repo. Already seen with oldest of 6.3 repo.
Comment 4 Telesto 2020-05-03 21:12:38 UTC
Created attachment 160301 [details]
Bibisect log

Bisected to
author	Vasily Melenchuk <Vasily.Melenchuk@cib.de>	2018-04-06 20:19:10 +0300
committer	Thorsten Behrens <Thorsten.Behrens@CIB.de>	2018-06-08 00:47:06 +0200
commit	1e55a47e89a9d9d6cf9cb3993484022aaf2c097b (patch)
tree	3a3372525645775c32721e59ce8c205c8f474ffd
parent	2a7f74900fb646235b74d4c9bd4690e44edc3ed4 (diff)
tdf#62268: allow row height recalculation on document load
During document load rows with style:use-optimal-row-height="true"
should recalculate it's height.

Comment 5 Telesto 2020-05-03 21:15:41 UTC
Adding cc to: Vasily Melenchuk
Comment 6 Xisco Faulí 2020-06-17 11:53:28 UTC
Not a regression. The issue can be reproduced if recalculation on File Load for ODF files is set to Always Recalculate in Tools/Options.../LibreOffice Calc/Formula
Comment 7 BogdanB 2020-09-19 11:43:43 UTC
In this case, if the user change that setting everything would be fine.

Philgood, could you try that?...See comment 6: Open Calc - Tools - Options - LibreOffice Calc - Formula - and change under Recalculation on File Load - instead of Never recalculate to Always recalculate.

Please test and tell us if this worked for you.