Changes

LibreOffice Tips and Tricks

85 bytes added, 19:10, 18 January 2018
The following lines were added (+) and removed (-):
When using Excel, a partial date entry such as MM-DD ie: 1-25 will automatically result in conversion to the configured format, for example MM/DD/YYYY or 1/25/2018.  This does not occur by default in Calc.  Although the ISO 8601 date format of YYYY-MM-DD is the most logical, it is not what Americans are accustomed to. When using Excel, a partial date entry such as MM-DD ie: 1-25 will automatically result in conversion to the configured format, for example MM/DD/YYYY or 1/25/2018.  This does not occur by default in Calc because Calc doesn't recognize the dash as a date separator.  This was not a problem in older versions (3.5x and earlier).   Tip: CTRL + ; will automatically enter the current date in the active cell.
Bureaucrat, administrator
16,192
edits