Description: table cells are converted to zero on LO Writer using style autoformat. Steps to Reproduce: 1. Create new writer document 2. go to menu Insert -> Table -> Insert Table and select Box List Blue 3. enter 5 or another number in rows field 4. Write any text in all cels 5. Close and reopen the file 6. add one row in the middle with some text 7. save the document and reopen it Actual Results: All second column data is converted to zero Expected Results: I would expect keep the same text no zero Reproducible: Always User Profile Reset: Yes Additional Info: version: 7.1.3.2 (x64) / LibreOffice Community 47f78053abe362b9384784d31... environment: CPU threads: 8; OS: Windows 10.0 Build 19041 user interface: Ul render: Skia/Vulkan; VCL: win locale: es-ES (es_ES); Ul: en-US
Created attachment 171838 [details] The video explain it in more detail, but also a way to fix it manually The video explain it in more detail, but also a way to fix it manually
Created attachment 171839 [details] the writer document that contains the table cells converted to zero
I have checked this on LibreOffice 7.1.3.2 (x64), Windows 10 (build 19042) The problem is easily replicated. The data in the cells shown with numbers in the Autoformat Style preview becomes zero when text is entered. It displays corrected when the document is open and active. However, when we reopen the file after Save and Close, the values in those cells of the LibreOffice/Writer Table become Zero. I have tried this several times and every time, this problem repeats exactly as mentioned in the bug report. This is very serious problem. We are unable to recover the lost text from within the LibreOffice/Writer.
Created attachment 171891 [details] Table Autoformat, Saved, Not Closed, Contents before close, reopen This odt file contains the tables before the file was closed. When this file is closed and reopened, the contents gets changed. Will provide that separately.
Created attachment 171892 [details] Table Autoformat, Saved, Closed, and Reopen This odt file contains the tables after Reopening (Save/ Close/ Reopen). The contents are changed. Some of the text becomes ZERO ('0')
Didn't test because looks duplicate. *** This bug has been marked as a duplicate of bug 131025 ***
Not sure if that one or bug 119377.
@Timur, It would be very very useful if you could fix that bug soon, I was able to recover my data thanks to someone who commented how to do it, but not all of us have the skills to do it and the truth is quite serious that bug. I had already lost my data since libreoffice 6.3 in July last year and I have been updating my LO to the newer version with the hope that it will be fixed in the next version. Regards
Lo is volunteer driven, so it's waiting for one. Bug is of highest importance already.
What I'm suggesting to users is this: Once we select the Predefined Table Format style, there are three options [Add]/ [Delete]/ [Rename]. Use the Delete option to remove each style (except the Default - it cannot be deleted). I have tried that. It works. I checked each of the style options. Every one of them leads to data loss in one situation or another. These Table Format Styles are not yet fully finished products. They seem to be work in progress. It is better not to include them because it will cause data loss for sure. We should not introduce data loss risk.
(In reply to Timur from comment #9) > Lo is volunteer driven, so it's waiting for one. Bug is of highest > importance already. Yes. We can wait for solution. However, until then do not include this in the package. That can be easily done.