[Solved] Enter Australian date format easily in LibreOffice

[Bootyou]

wish there was an australian version of LibreOffice as I have to write dates in tables backwards and it will be hard getting used to doing this so the dates look normal for OZ.

Edit: Changed subject, was Enter Australian date format easily in OpenOffice Make your post understandable by others  -- MrProgrammer, forum moderator

[floris v]

Enter the dates in a spreadsheet in the formatting that you want. First select a cell range in Calc, select Format cells, select Date and the formatting. Enter the dates. Select them, copy, switch to your Writer document, paste special as unformatted text.

This question is not related to your original question. Please ask new questions in a separate topic. (Please read Survival Guide for the forum.) I will split this part off to a new topic when you have posted a reply.

[JeJe]

With regular expressions ticked, you can use the Find/Replace dialog (you could also record this with the macro recorder and assign it to a toolbar button or shortcut)


From duckduckgo Search assist:

To change a date format using regex, you can use a pattern to match the original format and then specify a replacement format. For example, to change a date from "MM/DD/YYYY" to "YYYY-MM-DD", you can use the regex pattern (\d{2})\/(\d{2})\/(\d{4}) and replace it with $3-$1-$2.

[keme]

I will split this part off to a new topic when you have posted a reply.

Then this should follow in the split:

wish there was an australian version of LibreOffice as I have to write dates in tables backwards and it will be hard getting used to doing this so the dates look normal for OZ.

Advice on how to make dates LOOK right (formatting) has already been given. Maybe not necessary to follow explicitly (cf. mentions of "locale specifics" and "defaults" below), but probably no harm done if you did.
Note that the regex advice, as given by JeJe above, works (mostly) only for dates which have been entered as text. (Text entry usually happens by accident, because Calc fails to interpret them as proper date input).

To enable you to WRITE right (allow you to enter dates like you are used to by keyboard - and also alter other locale specific behavior, like default date formatting) do this:

• Select menu option Tools - Options
• In the left pane expand Languages and Locales
• Select General.
• Expand the second dropdown of this dialog - Locale setting
• Scroll down to select the option English (Australian)

[Bootyou]

Think I corrected the australian issue I was having. also Thank you Apache for the 20 or so years I have been using the alternative Office package it's been great I don't usethings like a buisness but been very handy for the home use I intend to continue using Open Office for spread sheets and stuff I only had to change for the DOCX file format. The right click number format was unreal Libre doesn't have this feature which was so handy be proud of yourselves. Also Thank You I started with star office then apache.