| Summary: | Calc stops refreshing result mid-way when copying formula more than 65536 rows | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Stephen <stephenletterbox> |
| Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | vitriol_vitriol |
| Priority: | medium | ||
| Version: | 3.4.0 Beta4 | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:3.5 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
sample ods
Results are only partially refreshed/displayed Formula are properly pasted; results are only partially refreshed/stopped in mid-way |
||
Created attachment 46599 [details]
Results are only partially refreshed/displayed
Created attachment 46600 [details]
Formula are properly pasted; results are only partially refreshed/stopped in mid-way
confirmed -> kohei Tested on both 3.4.5 and 3.5.0. Bug still exists on version 3.4.5 Fixed on 3.5.0. Test method: Tested copying formula for 1048576 rows. Compared both columns. Successfully copied without error. Thanks for the check. I think I know which one fixed this now that I think about it. |
Created attachment 46598 [details] sample ods How to reproduce: 1. open attached ods (a file with 100,000 cells with random generated text) 2. copy cell A1 3. paste on cells A2 to A100000 Missing refreshed results somewhere in mid-way (see "pasted_but_only_partial_refreshed.jpg"). Note: 1. Copy-paste works correctly for cells without formula. That is, calc works correctly when copy cells D1 to D100000 and paste on E1 to E100000. 2. Formula are properly pasted (see "formula_exist_but_not_refreshed.jpg"). Only the results have stopped displaying or refreshing in mid-way. 3. When the file is saved, closed and re-opened, all cells are displayed/refreshed correctly. 4. When number of rows smaller than 65536, calc refreshes correctly. It happens only when number of rows is greater than 65536 (probably a small bug of increased 65536 rows to 1 million rows) 5. Pressing recalculate (F9) has no effect on missing results. 6. The problem exists from LibO_3.3.2 to LibO 3.4.0 beta 4 My system: Windows xp sp3, 2G ram