Issue 113384 - Memory leak and crash pasting vlookup into range of cells
Summary: Memory leak and crash pasting vlookup into range of cells
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO330m1
Hardware: All Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: crash, regression
Depends on:
Blocks:
 
Reported: 2010-07-23 10:50 UTC by kpalagin
Modified: 2013-01-29 21:38 UTC (History)
1 user (show)

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

Attachments
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 kpalagin 2010-07-23 10:50:38 UTC 
(Confidential files will be sent to fst@openoffice)
Repro:
1. Open "Mega Belaya Dacha Draft July 2010.xls", answer No to "Update links?"
question.
2. Copy cell W3, select range W4:W10090 and press Ctrl-V.
3. soffice.bin starts allocating RAM and at some point crashes.
Comment 1 kpalagin 2010-07-23 11:10:55 UTC 
This is regression - 2.4.1 does not crash.
Comment 2 niklas.nebel 2010-07-23 12:22:51 UTC 
The formula in W3 has a relative reference for the data range, so when copying
it you use lots of different external ranges. This is probably not what you
want, so you should use an absolute reference there.

I might be possible to optimize memory usage for overlapping external ranges,
but it doesn't seem very important. 2.4.1 still used a hidden sheet for the
external references.
Comment 3 kpalagin 2010-07-23 12:32:37 UTC 
Niklas,
thanks a lot! I indeed need absolute references (please consider
http://www.openoffice.org/issues/show_bug.cgi?id=23098)!