Re: [sc-dev] Filling dates in Calc

2008-10-30 Thread Stefan Weigel
Hi, Leonard Mada schrieb: Oh, I forgot to press shift. Though, selecting 2 cells with the same entry should have worked as well. I actually feel that automatic date increment is less useful (because one does not have control on what changes), so that keeping the date constant, when 2 cells are

Re: [sc-dev] Filling dates in Calc

2008-10-30 Thread Eike Rathke
Hi Niklas, On Thursday, 2008-10-30 09:42:30 +0100, Niklas Nebel wrote: >> If I select 2 or more equal dates, and try to fill, the date still gets >> incremented. This is not the case with ordinary numbers. > > Two numbers lead to "linear" fill, no special handling for the "equal" > case there.

Re: [sc-dev] Filling dates in Calc

2008-10-30 Thread Eike Rathke
Hi Leonard, On Thursday, 2008-10-30 02:10:33 +0200, Leonard Mada wrote: > I will present a more global solution addressing the FILL on the OASIS > list. Please note that the OASIS ODF TC works on the file format and the formula subcommittee on specifying spreadsheet functions and operators and

Re: [sc-dev] Filling dates in Calc

2008-10-30 Thread Niklas Nebel
On 10/30/08 01:10, Leonard Mada wrote: What do you mean as simple fill? If I select 2 or more equal dates, and try to fill, the date still gets incremented. This is not the case with ordinary numbers. This is the reason, I supposed that the fill is broken (and basically it is, because it doesn

Re: [sc-dev] Filling dates in Calc

2008-10-29 Thread Leonard Mada
Hello Niklas, I will present a more global solution addressing the FILL on the OASIS list. Unfortunately, I am rather limited in free time, but I still try to do it over the weekend. Niklas Nebel wrote: On 10/24/08 12:35, Leonard Mada wrote: Oh, I forgot to press shift. Though, selecting 2

Re: [sc-dev] Filling dates in Calc

2008-10-24 Thread Niklas Nebel
On 10/24/08 12:35, Leonard Mada wrote: Oh, I forgot to press shift. Though, selecting 2 cells with the same entry should have worked as well. I actually feel that automatic date increment is less useful (because one does not have control on what changes), so that keeping the date constant, when

Re: [sc-dev] Filling dates in Calc

2008-10-24 Thread Stefan Weigel
Hi, Leonard Mada schrieb: I worked late last night and needed to fill in dates in Calc. Actually I needed to fill the same date in a variable number of cells. You could select the range of cells, that should get the same entry, first. Then type it in and close with {ALT}+{ENTER}. Stefan -

Re: [sc-dev] Filling dates in Calc

2008-10-24 Thread Leonard Mada
Oh, I forgot to press shift. Though, selecting 2 cells with the same entry should have worked as well. I actually feel that automatic date increment is less useful (because one does not have control on what changes), so that keeping the date constant, when 2 cells are selected is the far better

[sc-dev] Filling dates in Calc

2008-10-24 Thread Leonard Mada
Hello everyone, I worked late last night and needed to fill in dates in Calc. Actually I needed to fill the same date in a variable number of cells. I entered the same date in 2 adjacent cells and tried to drag the right corner (after selecting both cells), but Calc continued to increment the