[Libreoffice-bugs] [Bug 119377] Table text replaced by '0' on applying AutoFormat Style and re-opening document

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119377

--- Comment #9 from Walter Nicholls <walter.nicholls at cornerstone.co.nz> ---
Reproduced (or discovered anew).
Version: 6.1.2.1
Build ID: 1:6.1.2-0ubuntu1.1
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
Locale: en-NZ (en_NZ.UTF-8); Calc: group threaded

Seems to me that it definitely happens when the top-left cell of the table
contains only a number or number-like text, but I won't say that is the only
one. 


I did a couple of tests, screenshot attached. 


If this loss-of-information bug has been around since LO 4.4 I'm astonished it
wasn't found earlier. This probably shows noone in their right mind used table
autoformats!
And Table Styles .. were supposed to be a feature point for LO 6 but just seem
to have added a new set of bugs on top of a flaky foundation!

I guess this is a "format this cell as a number" thing, so the underlying text
effectively evaluates to zero

To add insult to injury, I can't find any reasonable way to get the text back.
  - setting number format to "Text" (format code @) intead of General doesn't
work
 - you can't remove a table style - either from the table (no UI for that) or
delete the style completely

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181129/65662ec5/attachment.html>