Bug 142202 - table cells are converted to zero on LO Writer using style autoformat
Summary: table cells are converted to zero on LO Writer using style autoformat
Status: RESOLVED DUPLICATE of bug 131025
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.1.3.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-10 21:39 UTC by Diego
Modified: 2021-05-13 15:42 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
The video explain it in more detail, but also a way to fix it manually (15.71 MB, video/mp4)
2021-05-10 21:58 UTC, Diego
Details
the writer document that contains the table cells converted to zero (10.51 KB, application/octet-stream)
2021-05-10 22:02 UTC, Diego
Details
Table Autoformat, Saved, Not Closed, Contents before close, reopen (14.69 KB, text/plain)
2021-05-11 17:59 UTC, Chandanathil P. Geevan
Details
Table Autoformat, Saved, Closed, and Reopen (14.60 KB, application/vnd.oasis.opendocument.text)
2021-05-11 18:08 UTC, Chandanathil P. Geevan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Diego 2021-05-10 21:39:16 UTC
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
Comment 1 Diego 2021-05-10 21:58:48 UTC
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
Comment 2 Diego 2021-05-10 22:02:44 UTC
Created attachment 171839 [details]
the writer document that contains the table cells converted to zero
Comment 3 Chandanathil P. Geevan 2021-05-11 16:29:39 UTC
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.
Comment 4 Chandanathil P. Geevan 2021-05-11 17:59:39 UTC
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.
Comment 5 Chandanathil P. Geevan 2021-05-11 18:08:53 UTC
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')
Comment 6 Timur 2021-05-12 11:03:30 UTC
Didn't test because looks duplicate.

*** This bug has been marked as a duplicate of bug 131025 ***
Comment 7 Timur 2021-05-12 11:10:23 UTC
Not sure if that one or bug 119377.
Comment 8 Diego 2021-05-13 03:06:46 UTC
@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
Comment 9 Timur 2021-05-13 06:54:43 UTC
Lo is volunteer driven, so it's waiting for one. Bug is of highest importance already.
Comment 10 Chandanathil P. Geevan 2021-05-13 15:40:22 UTC
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.
Comment 11 Chandanathil P. Geevan 2021-05-13 15:42:06 UTC
(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.