First time here? Check out the FAQ!
When I open the file I need to work on, LO Calc 3.3.4 automatically interprets some cells as date and changes their values. For example the cell content '4-6' gets converted to '06-Apr'. If I then change its format to text it becomes '41005'. I tried different options, Expand Formatting,language separator, etc without any luck. I can't put a ' in front of the content because by the time I can edit the file is already changed. How can I get LO to respect the value '4-6' as is?
answered 2013-03-14 00:14:19 +0200Mark12547
A trick I have used in Excel and I suspect would also work in Calc is to select the cell (or, in my case, highlight the whole column by clicking on the column heading), and then going into "Format" -> "Format Cells" (or Ctl+1 which is CTL + the digit 1), scrolling down the "Category" column, and clicking on text. That way, what is entered in that cell is interpreted as text, not as a date, not as a number, but as text.
Of course, this requires that the file would then subsequently be saved with the cell formatted as a category of "Text".
If this doesn't help, please explain in more detail what you are doing. Are you opening a non-LibreOffice file and allowing it to convert, or opening a .CSV file (and does it include quotes around the text of text columns?), or are you doing something else?
answered 2012-07-21 01:48:43 +0200mariosv
What kind of file are you opening?. It is a native .ods file?
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-07-21 00:51:51 +0200
Seen: 248 times
Last updated: Mar 14