How do you fix the time format in writer, table column, without having to set it for each line?
Please edit tour question (= modify it, don’t use a comment) to elaborate more: describe what you have first (an existing table with several rows and columns; a fresh new table; …), what you’re doing (filling in an empty table; adding a new row with Tab in the last cell; …), what you expect, …
Give us enough details to understand your goal and your problem.
And, as always, mention OS name, LO version and save format (most solutions are guaranteed to be stable only under native .odt format).
My naive answer is I know of no trick to pre-format a new table, but you can select an entire row or column in a existing table and `Table`>`Number Format` to apply one to the selection. When you hit Tab in the last cell, a new row is added with the same formatting has the previous row.
Works for me.
- menu:Table>“Number recognition” = ON.
- Select the column and apply a number format via menu:Table>“Number format”.
- Have a look the date acceptance patterns at menu:Tools>Options>Language Settings>Languages.
2/ enters this months second day.
2/3/ enters this year’s second of March (or 3rd of February in US context).
2/3/4 enters 2nd of March 2004 (or 3rd of February in US context).
An ISO date such as 2004-3-2 will always be accepted.
No matter how you enter a recognizable date, the resulting date will be displayed in the chosen format, for instance as “Tuesday, 2 March 2004”.
1 Like
Using Windows 10 Home. Have been using Open Office, but it crashes now and then, causing problems. When creating tables I was able to set the time format as default for all tables, but it appears this cannot be done in Libre Office. I would expect a default setting to remain unless cancelled, not having to be reset for evcery column required.
expected this on MS-DOS, but not in multi-tasking environments, where I can edit several documents from different sources at the same time. There I expect settings per document to be kept and for documents in several languages, I expect even different settings per paragraph/column/cell, but I admit, it is nice to have decent defaults…
Unsurprisingly, the setting is in the same place as OpenOffice.
Click Tools > Options > LibreOffice Writer > Table and under the heading of Input in Tables, tick the top two of three boxes, Number recognition and Number format recognition, maybe you want Alignment too.
[Edit]
Important: Always use Table Style None otherwise the table macro will override the formatting on next change.
94809.odt (13.0 KB)
Enter a date according to your date acceptance pattern, hit tab, enter the next date.
You might find it helpful to look in the online help for “time format.” If you scroll down the page, you will see information about entering dates and times, as well as formatting them.