Apache OpenOffice (AOO) Bugzilla – Issue 114346
Autofill of formula fails over 65536 lines
Last modified: 2013-05-07 15:53:22 UTC
1. Fill the cell C65535 in a table with the formula e.g. =LÄNGE(B65535) (German Länge = Length). 2. Then drag the autofill-area in the cell and drag the mouse downward over e.g. 10 lines. 3. The Result in line C65536 is NOT the expected = LÄNGE(B65536) but =LÄNGE (B1) 4. The Result in line C65537 is NOT the expected = LÄNGE(B65537) but =LÄNGE (B2) and so on. So the error is: counting starts at line 65537 from line 1 , if xou use autofill !!
cannot reproduce in OOO330m6
tested on Solaris x86
I attempted to reproduce the defect you reported but was unsuccessful. I tested the following scenario: 1. Open up AOO 3.4.1 Calc 2. Turn on the autofill: Tools->Cell contents-> AutoInput 3. Fill the cell C65535 in a table with the formula e.g. = LÄNGE(B65535) 4. Drag the autofill area in the cell and drag the mouse downward over e.g 10 lines. 5. The result in line C65536 is the expected = LÄNGE(B65536) 6. The result in line C65537 is the expected = LÄNGE(B65537) All 10 lines have the expected result. I'm marking this issue as RESOLVED/IRREPRODUCIBLE. If we receive more information on how to reproduce the issue, we can reopen.
We didn't receive more details about this issue, so I couldn't reproduce it. Regards, Daniel Alvaro