Re: [sc-dev] Filling dates in Calc
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't work as for simple numbers). Strangely, filling using the menu works as expected (though you can't trigger increment on). Two numbers lead to linear fill, no special handling for the equal case there. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Filling dates in Calc
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 how they behave in expressions. Application behavior such as fill operations are not on topic. 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't work as for simple numbers). That indeed looks weird. May be worth an issue, if there isn't one already. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpEp3IYVHiVm.pgp Description: PGP signature
Re: [sc-dev] Filling dates in Calc
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. For dates, in ScTable::FillAuto() FillAnalyse() is called that for this case correctly determines nInc to be 0, but sets eFillCmd to FILL_SIMPLE. In the following (eFillCmd == FILL_SIMPLE) path the nInc value is not used, but nDelta set to 1 instead. For numbers, FillAnalyse() determines nInc=0 as well, but sets eFillCmd to FILL_LINEAR that then acts correctly in the else path. Looks like FillAnalyse() simply fails to set the FillCmd to FILL_DATE for equal dates, and FillDateCmd to FILL_DAY. Only by review, untested for possible side effects. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. pgpQKVHs7FGr1.pgp Description: PGP signature
Re: [sc-dev] Filling dates in Calc
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 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 alternative. Two equal dates are already recognized as simple fill. 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't work as for simple numbers). Strangely, filling using the menu works as expected (though you can't trigger increment on). I do not see any use case to select 2 or more equal dates and to expect that filling will increment these values (especially the day in the date). In the rare instance that something like this is desired, let the user activate increment using CTRL. [I made a mistake in my previous post, it is CTRL, not SHIFT.] By the way, CTRL doesn't trigger INCREMENT, when used on simple numbers. And there is no way to do an increment, if selecting 2 equal numbers, a much more common scenario than incrementing the day when selecting 2 or more equal dates. Sincerely, Leonard But simple fill always uses the Ctrl key to enable/disable the increment. This is done the same way for all kinds of source data, to keep consistent. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Filling dates in Calc
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 alternative. Sincerely, Leonard Leonard Mada wrote: 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 date in pairs of 2. Is this bug already reported? A quick search on bugzilla did not yield any results. Using the Menu entry fills as expected, but this is cumbersome. Why shouldn't this work in a single step? I need to drag manually because I do not fill the whole column. I am using OOo dev300-m29. Sincerely, Leonard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] Filling dates in Calc
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 date in pairs of 2. Is this bug already reported? A quick search on bugzilla did not yield any results. Using the Menu entry fills as expected, but this is cumbersome. Why shouldn't this work in a single step? I need to drag manually because I do not fill the whole column. I am using OOo dev300-m29. Sincerely, Leonard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Filling dates in Calc
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 -- www.datenpilot.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]