https://bugs.documentfoundation.org/show_bug.cgi?id=101225
--- Comment #6 from Colin <[email protected]> ---
In which case the error is probably in the formatting/format interpretation
functionality. I had previously selected the entire column and set it to Number
- general as you can see from that uploaded spreadsheet.
I have now tried selecting the two cells which could be sequentially copied to
provide the Numeric - general format on the table therein and still the
function remains as a text string not a formula.
I then tried selecting just the two cells as above and simply selected reset.
Still no change.
I can confirm that the reformatting attempts indeed report that the two cells
(the entire column) are formatted as number - general but that still doesn't
prevent it from treating the contents as a text string.
Would you like me to provide a further copy of the spreadsheet upon which I
have exercised the above two reformatting options or will you try it yourself
on the version you already have? Hint: to make sure we were both working with
the same spread I actually downloaded that one attached to the bug report and
tested your suggestion on that.
Are you merely convinced the formatting, as you have described it, works as it
should or, have you actually attempted to reformat the cells directly yourself
and confirmed that the reformatting produces a function rather than leaving it
as a text string?
If it works for you then is it conceivable that the update of a couple of days
ago simply resulted in a corrupted version for me?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
