Am 15.07.2015 um 22:06 schrieb Gilles: > Hello > > I often use Calc to prepare multi-day trips, and have to write series that > look like this: > > Mon 1 Aug > Tue 2 Aug > Wed 3 Aug > etc. > > Does Calc come with a way to automate this tedious task, or is there some > macro that I could copy/paste from somewhere? > > Thank you. >
Generally speaking, you can enter dates any way you want and get the resulting date displayed in the way how you format the cells. Formatting the cells does not affect the input method. "Normal" spreadsheet programs (not LO Calc) accept date input like this: 5/ --> 5th of current month 5/6 --> this year's 5th of June or 6th of May with US English locale 5/6/14 --> 5th of June 2014 according to the global settings for 2-digit years. You can enter digits together with localized month names according to the current locale setting. It recognizes short and long month names of 180 languages. In any case you should _never_ enter any weekday names. Entering dates into LibreOffice is particularly difficult since version 3.6. To make above mentioned input patterns working in LibreOffice, you need to adjust the "date recognition patterns" in the language settings. The output with or without weekday names, month names 2 or 4 digit years looks like you formatted the cells. The formatting of a cell never makes any difference. The value remains the same. PLEASE turn on menu:View>HighlightValues [Ctrl+F8]. This highlights all numeric values in blue font. If your dates are displayed in black font, they are no dates at all. If you do not set the alignment of the cell, all numbers are right aligned to the cell border whereas all text values are left aligned. For any valid date in A1, =ISNUMBER(A1) should return TRUE. ------------------------------ Now for the series of dates: ------------------------------ Enter one valid date so it appears in blue font and/or right aligned. Drag down the cell handle (little square in the bottom-right corner). Easy, isn't it? -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
