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 +0000
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 text 1.1 text 1.1 text
2 text 2.1 text 2.2 text
============================== after autofilling =>
1 text 1.1 text 1.1 text
2 text 2.1 text !2.1 text! <== HAS CHANGED !!!
3 text 3.1 text 3.1 text
4 text 4.1 text 4.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]
