[sc-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 User er changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Wed Sep 17 12:35:03 + 2008 --- Issue 5550 has a patch attached to change how increment is determined. Please evaluate. *** This issue has been marked as a duplicate of 5550 *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - 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-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 User er changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Wed Sep 17 12:36:07 + 2008 --- Closing dupe. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - 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-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 --- Additional comments from [EMAIL PROTECTED] Thu Aug 7 08:41:20 + 2008 --- Hallo Eike! Overwriting of existing values during AutoFill is fine, as long as they are NOT part of the selection when starting AutoFill. But, selected cells must not be changed. You may wanna check the main competitor´s behaviour, that IMHO fits best to the user´s expectations in any constellation prior to AutoFill. (Damn, how do I hate stating this.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - 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-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92292
User discoleo changed the following:
What|Old value |New value
CC|'sweigel' |'discoleo,sweigel'
--- Additional comments from [EMAIL PROTECTED] Thu Aug 7 17:17:29 +
2008 ---
I did some testing in OOo-dev m28
I entered in the first 2 cells a string and examined what happens when
autofilling (using the drag method):
Text entered in first 2 rows:
A B C
--
1 text1.1 text1.1 text
2 text2.1 text2.2 text
== after autofilling =
1 text1.1 text1.1 text
2 text2.1 text !2.1 text! == HAS CHANGED !!!
3 text3.1 text3.1 text
4 text4.1 text4.1 text
Cell C2 should have never changed: at a minimum, it should not change, even IF
the other cells are undefined.
The optimal solution would be to detect the common string parts in the first 2
cells, remove them, and use the remaining numbers to increment.
Alternatively, one could extract the whole number sequence.
IF(cell_content == string) {
ITERATOR = first_pos(cell_content)
while(ITERATOR end) {
IF( *ITERATOR++ == number ) next
IF( *ITERATOR++ == locale_dependent(.) ) {
decimal_separator++
# we can also have dates or date-like strings
IF( decimal_separator 3) next
ITERATOR--
# this is a decimal separator too much
# will break after this
}
break
}
# we found our number-sequence
}
The alternative is to compare the 2 strings and extract ALL identical strings.
Try to interpret as a number everything else that remains (that is different
between the 2 strings).
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
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-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 --- Additional comments from [EMAIL PROTECTED] Thu Aug 7 17:41:52 + 2008 --- Just to slightly update the described algorithm: - IF NO number sequence is found at the beginning of the string then the iterator should start backwards [left should have precedence over right] - this algorithm will fail with discontinues numbers, e.g. 1 text 1 2 text 2 The identical string algorithm would be slightly more stable, but would fail IF the true string part is different, e.g. 1 abc 1 2 axx 2 The behaviour would be undefined in this latter instance. Also, this latter algorithm would then have to increment every number sequence encountered (with possibly different steps). Though, this needs not be implemented immediately. Fixing the overwrite behaviour should however be fixed in a timely manner. Detecting a whole number sequence should probably follow closely. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - 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-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 --- Additional comments from [EMAIL PROTECTED] Thu Aug 7 01:13:37 + 2008 --- When filling strings only a simple are there leading or trailing digits detection and determining a step value is performed, no other numeric conversion is involved, especially no conversion of alleged floating point values and no pattern match. Replacing item 2.2 with item 1.2 may be considered wrong. But if left intact, what would you expect as a 3rd value? item 3.3? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - 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-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 --- Additional comments from [EMAIL PROTECTED] Thu Aug 7 04:27:37 + 2008 --- Thats not important, maybe item 2.3 even if it is not expected, just I dont like that existing values are modified. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - 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-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 Issue #|92292 Summary|automatic filling of cells doesnt work as expected Component|Spreadsheet Version|DEV300m28 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|vagula --- Additional comments from [EMAIL PROTECTED] Wed Jul 30 17:59:29 + 2008 --- I entered into spreadsheet following entries under each other (dev300_m27): item 1.1 item 2.2 Selected both cells and dragged right corner down. Spreadsheet is filled like: item 1.1 item 1.2 item 1.3 item 1.4 As you see, Calc has its own opinion about my list and much worse, it replaces my second entry 2.2 with 1.2. (instead period here can be dash or something else). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - 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-issues] [Issue 92292] automatic filling of cells doesnt work as expected
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92292 User sweigel changed the following: What|Old value |New value CC|''|'sweigel' --- Additional comments from [EMAIL PROTECTED] Wed Jul 30 19:35:59 + 2008 --- When looking at this issue, may I draw your attention also at issue #70015, issue #74662 and issue #74733 that deal with improvements for AutoFill as well . - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - 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]
