[Libreoffice-bugs] [Bug 108245] Change column format to "Date" adds ' to the beginning of field

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Jacques Guilleron <guilleron29 at aol.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170601/87cca463/attachment.html>