Ask Your Question

How do you disable date formatting in LibreOffice Calc?

asked 2019-01-29 20:03:55 +0200

Cruzy gravatar image

There are dozens of questions with this title and not one of them says how to actually disable date formatting. Please, if anyone knows how to just turn it off, please share.

I've disabled all auto-formatting that I can find under Tools->Auto Correct Options, but LibreOffice still tries to put a year on the text I just entered. There is no year. It's not a fraction. I just need my text left alone without having to type extra text that doesn't belong, like a leading space and zero.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-01-29 20:15:12 +0200

You don't need to disable anything to do what you need. If you need some (all) cells to not try to analyze your input, but just accept it as text, then prior to input, you need to format the cells as text. You may create a cell style specially for that, or even modify Default style to have all cells have it automatically.

edit flag offensive delete link more


How do you "format the cells as text"?

Cruzy gravatar imageCruzy ( 2019-01-29 20:52:38 +0200 )edit

Thank you. I would upvote, but this forum won't let me. Just in case, is there some way to actually disable it? If I drag cells down and then type in the spaces between it reverts back to formatting them. I suspect that the truest answer to the original question is that you can't.

Cruzy gravatar imageCruzy ( 2019-01-29 22:26:51 +0200 )edit

I mentioned that you should consider applying the formatting at style level. That gives you the possibility you need.

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-29 22:33:32 +0200 )edit

answered 2019-01-30 01:33:41 +0200

Cruzy gravatar image

The truest answer is that no, you cannot disable it. Thank you very much Mike Kaganski for the work around which is summarized here:

  1. Highlight and right click the cells you want to leave unformatted.
  2. Click "Format Cells..."
  3. Click on the tab "Numbers"
  4. Under the category select box click "Text"
  5. Click "Ok".

Your text should no longer be interpreted as date/decimal/currency etc for the selected cells.

A few caveats. If you insert a cell then the LibreOffice Calc will revert to it's old behavior for that cell. This includes dragging and dropping the contents of a cell to somewhere lower in the document. The spaces made will revert back to the old behavior.

edit flag offensive delete link more



This is totally incorrect interpretation.

Text cell formatting is specifically what you were asking for: disable any interpretation of entered text, and store it as-is.

If you need robust behavior in cases of additions/movements of cells, you need to apply the formatting to the whole column(s). As you seem to want to just disable the detection, (you don't mention that you want it in some cells only) which might mean that you are using spreadsheet an a big text table, it might mean that it's enough to modify Default cell style to have Text formatting. That's all, and that gives you the spreadsheet without any input interpretation.

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-30 09:32:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-29 20:03:55 +0200

Seen: 265 times

Last updated: Jan 30