Issue 68057 - Strange dragging behaviour for calendar date
Summary: Strange dragging behaviour for calendar date
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-08-02 01:28 UTC by romolo
Modified: 2013-08-07 15:12 UTC (History)
6 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
spreadsheet demonstrates different behaviour for different data (8.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-08-02 13:37 UTC, Rainer Bielefeld 		no flags Details
Dragging of three different spreadsheets (31.40 KB, image/png)
2006-08-08 22:50 UTC, romolo 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description romolo 2006-08-02 01:28:49 UTC 
Open a new spreadsheed, 
write in A1: 1, in A2: 1, select A1-A2 drag using the bottom right corner on A3-
A12 and it will fill A3-A12 with 1 (right behaviour)
Write in A1: jan, in A2: jan, select A1-A2 drag using the bottom right corner 
on A3-A12 and it will fill A3-A12 with feb,mar,apr,maj,jun,jul,aug,sep,oct,nov 
(wrong behaviour)
The problem is present at least in the italian release of OOo, check on other 
language, the name of the months are translated just to clarify, the test was 
made with gen,gen and corrispondant italian months.
Comment 1 Rainer Bielefeld 2006-08-02 13:36:11 UTC 
I checked with "2.0.2  German version WIN XP: [680m5(Build9011)]" and was able
to reproduce the reported behaviour for cell content "calendar date". All other
works as expected, as you can see in my attached 'mytest.ods'

@romolo:
Pls. specify your OS and Platform!
Comment 2 Rainer Bielefeld 2006-08-02 13:37:07 UTC 
Created attachment 38201 [details]
spreadsheet demonstrates different behaviour for different data
Comment 3 Rainer Bielefeld 2006-08-02 14:01:27 UTC 
It's nothing new, I also see that "1.1.4 (German) WIN XP: [645m52 (Build 8824)]"
Comment 4 romolo 2006-08-02 21:43:24 UTC 
platform 
intel x86: win2k sp4, winxp sp2, suse linux 10.0, suse linux 10.1
amd athlon 64: suse linux 10.0, suse linux 10.1
Comment 5 frank 2006-08-08 15:46:42 UTC 
Hi,

IMHO neither a bug nor an enhancement. TZhe problem is just that the sortlist
get a higher priority than the selection. I think this is more logical.

Nevertheless I re-assign this as enhancement to the requirementsteam for
decission finding.

Frank
Comment 6 romolo 2006-08-08 22:22:41 UTC 
I will prefer to have this issue marked as defect, it's causing a lot of 
confusion in 80+ users I forced to migrate to openoffice. 
Furthermore for migration is incongruent with the behaviour of the concurrency.
No other spreadsheet in this world behaves like that.
Comment 7 romolo 2006-08-08 22:50:46 UTC 
Created attachment 38353 [details]
Dragging of three different spreadsheets
Comment 8 kpalagin 2008-12-07 20:51:10 UTC 
The problem is that drag-filling by two equal dates produces the same results 
as for Jan-Jan - enter 1.1.1 in A1 and A2, select A1:A2 and drag-fill down - 
you will get date increment (as opposed to integers.
See http://sc.openoffice.org/servlets/BrowseList?
list=dev&by=thread&from=2141368