https://bugs.documentfoundation.org/show_bug.cgi?id=108245
--- Comment #10 from Jacques Guilleron <[email protected]> ---
Created attachment 133785
--> https://bugs.documentfoundation.org/attachment.cgi?id=133785&action=edit
a way to reproduce.
This is the usual behaviour.
Most of the time, those apostrophes (simple quote marks) are added when we
import table from web or a database.
They are texts and, with or without apostrophe, they are aligned to left.
This behaviour can be reproduce. I joined a document to show how it works.
Column A was first text formated and filled next with numbers.
Column B is a copie of column A, but an apostrophe was automaticly added at the
copie time.
Column D is get from column C by a formula, and give also a quoted column E by
copie.
Column B as column E can be transform to values by selecting them and
Data > Text to columns…
Another way to do that is to multiply by 1
or use a formula like =VALUE()
Ok for the beer the next time we meet.
Jacques
--
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
