How can I deactivate the automatic date formatting when I paste numbers from writer to calc. 1.1, 1.2, 2.1 ... are falsely converted to dates. I am using the localised (German) version of LibreOffice.
Before pasting from the clipboard assign the number format Text to the cells to be pasted on. For manual input the input can be preceded with a ' single quote character. Both methods force the input to text and not be interpreted.
LibO 3.6.0 will act differently based on locale dependent date acceptance patterns for incomplete dates, e.g. in a German de_DE locale 1.2 would not yield a date, only 1.2. would.
Note that as of LibreOffice 3.6.2 the date recognition is more strict and depends on locale specific patterns and you can also define the date acceptance patterns, see https://wiki.documentfoundation.org/ReleaseNotes/3.6#Localization
If you import with paste unformatted text, you can select the format, while in the import box, click the header of the column and in the upper box select the format.
answered 2012-09-15 23:13:28 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
It is really a stupidly predefined behavior. I use Calc regularly, but I do only in the rarest situation use dates. It is very annoying to be forced in a new sheet to format cells. The natural content of a cell is a number. Anything else should be set by the user.
Your current default language most likely uses the dot "." as a separator for dates.
You can specify this in Tools>Options>Language settings>Languages, by setting Decimal separator key to Same as locale setting (or not: experiment to see what's best for you).
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-02-29 11:45:32 +0200
Seen: 2,887 times
Last updated: Jan 03
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Hi @laxas, Did you ever find a satisfactory answer to your problem? If not, perhaps you could tag your question as a feature-request?
qubit ( 2013-01-20 21:37:20 +0200 )edit