Am 16.07.2015 um 23:08 schrieb Tom Davies:
> Hi :)
> If it's spread out into 2 columns (or rows) such that the day-of-the-week
> (eg Mon) is in the first cell and then the date part is in the next cell
> then both drag down fine. (I had to set the format of the cell before it
> let me show the dat
Hi :)
If it's spread out into 2 columns (or rows) such that the day-of-the-week
(eg Mon) is in the first cell and then the date part is in the next cell
then both drag down fine. (I had to set the format of the cell before it
let me show the date in "MMM d" format but that's a side-issue imo).
So
Andreas Säger wrote:
> Problem is that too many spreadsheet users do not know what a
> spreadsheet date/time is and how it differs from a text such as
> "16/07/2015" which is not a date by any means.
Actually it is if you add the pattern to Options > Language Settings >
Languages > Date Accep
Am 16.07.2015 um 18:49 schrieb tonybsa:
>
> The secret i using the Edit > Fill > Series menu options
>
> So now you have the dates, with days in the A column you could put time along
> the the row 1.
> Starting at B1 and use the Edit > Fill > Series >Right > Date . Start 08:00,
> End 12:00 Inc
Use Edit > Fill > Series
Click in cell A2
Right click Format Cells > date > Fri, 31Dec 99 > OK
With A2 still selected shift click A6
Click Edit>Fill>Series
When the dialog box opens
Select Down > Date > Day
Enter start date: 3/08/2015
Enter finish date: 7/08/2015
Increment: 1
Click OK
Result:
M
P.S.
Am 16.07.2015 um 16:05 schrieb Andreas Säger:
> 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 recogni
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/pas
I use this a lot.
Format the column the way you want it.
Put a date in the first cell
A formula goes in the cell below =A1+1
Fill from that formula down
Copy the the entries
Paste Special with values into the same area.
Works for me
John
On 16/07/2015 6:24 AM, Gilles wrote:
Found it: What yo
Yup yup, thus why it's a good request. Although - what do you think should
happen if they put "M 1 Aug" or even worse if they put "T 1 Aug" when 1-Aug
is actually a Mondaycould become a bit tricky (as any automagic stuff
tends to become).
Best,
Joel
On Wed, Jul 15, 2015 at 2:14 PM, Gilles wr
Right.
Makes sense: If a column or set of cells was formated as Date, LO knows what
to do with it. But users might start with a full "Mon 1 Aug" and try to get
LO to complete the series automagically.
--
View this message in context:
http://nabble.documentfoundation.org/Calc-Automate-creation-
Funny enough if you remove Monday from the entry and just put Aug 1 and
then Aug 2, things work ;)
On Wed, Jul 15, 2015 at 2:06 PM, Joel Madero wrote:
> Ah yes I do see that (Excel has same behavior). I would have quoted
> "smart" instead of "that" ;)
>
> But I think that detecting Mon 1 Aug as
To make matters worse - or more interesting, progammatically speaking -, I
could be running the French version of LO and type "Mon" instead of "Lun"
;-)
--
View this message in context:
http://nabble.documentfoundation.org/Calc-Automate-creation-of-series-of-full-date-ie-Day-name-Date-tp4154586
Ah yes I do see that (Excel has same behavior). I would have quoted "smart"
instead of "that" ;)
But I think that detecting Mon 1 Aug as a date makes sense. I'll file an
enhancement request.
Best,
Joel
On Wed, Jul 15, 2015 at 1:45 PM, Gilles wrote:
> I simply typed "Mon 1 Aug" and expected LO
I simply typed "Mon 1 Aug" and expected LO to figure it out.
But I guess the doco should say that user must first start with a simple
DD/MM/, before telling LO that it's a date, and clicking to get a
series. Computers are not *that* smart ;-)
--
View this message in context:
http://nabble.
I'm interested in that observation - might be worth reporting a bug or
enhancement request. You shouldn't have to type exactly the same format (if
you apply the format after you type it in the cells). Can you shoot me an
email privately with a simple attachment with a sample of what did not work
fo
Found it: What you type in the cell must match exactly the format chosen in
the Format Cells dialog, in the Format section.
For instance, if you choose "Fri. 31 Dec. 99", that is exactly what you must
type for LO to figure things out.
Thanks a lot!
--
View this message in context:
http://nabb
Thanks but no go: Even after telling LO that it's a Date, it simply copies
the contents instead of incrementing it:
Right-click > Format Cells > Numbers >
Category = Date
OK
Drag:
Mon 1 Aug
Mon 1 Aug
Mon 1 Aug
Mon 1 Aug
etc.
--
View this message in context:
http://nabble.documentfoundation.o
17 matches
Mail list logo