Am 15.07.2015 um 22:06 schrieb Gilles:
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
Does Calc come with a way to automate this tedious task, or is there some
macro that I could copy/paste from somewhere?
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: firstname.lastname@example.org
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
[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)? · Andreas Säger
- [libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)? (continued)
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy