Issue 105873

Summary: formula mass-paste doesn't work properly in large files
Product: Calc Reporter: ezdvf <pieboy_100>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kyoshida, raal
Version: OOO310m9   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
spreadsheet with 115k rows none

Description ezdvf 2009-10-13 16:12:54 UTC
1) get a very large spreadsheet (more than 100k rows): http://c.shell.tor.hu/
large.ods
2) enter any formula in the first row ( say, B1=left(A1;5) )
3) copy the cell (ctrl+C), select all empty cells below (ctrl+shift+End), paste 
(ctrl+V)
4) observe the bug :) (cells B48975 and below are empty and if you try editing 
them, the app crashes, log below).

Btw, the version is OOO310m19 (build 9420), running on Debian sid.

*** glibc detected *** /usr/lib/openoffice/program/soffice.bin: free(): invalid 
pointer: 0xb45ee000 ***
======= Backtrace: =========
/lib/i686/cmov/libc.so.6[0xb7c408f4]
/lib/i686/cmov/libc.so.6(cfree+0x96)[0xb7c42896]
/usr/lib/openoffice/program/../basis-link/ure-link/lib/
libuno_sal.so.3(rtl_freeMemory+0x1d)[0xb7eebc3d]
/usr/lib/openoffice/program/soffice.bin(_ZdlPv+0x21)[0x8048e41]
/usr/lib/openoffice/program/../basis-link/program/libforli.so
(_ZN7formula12FormulaTokenD0Ev+0x28)[0xafdef088]
/usr/lib/openoffice/program/../basis-link/program/libscli.so
(_ZN13ScFormulaCellD0Ev+0x7c)[0xb119b80c]
/usr/lib/openoffice/program/../basis-link/program/libscli.so
(_ZN10ScBaseCell6DeleteEv+0xe8)[0xb119c008]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb11b4f6d]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb1289f0c]
/usr/lib/openoffice/program/../basis-link/program/libscli.so
(_ZN10ScDocument7PutCellEslsP10ScBaseCellh+0x67)[0xb11efe07]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb0e9ec9c]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb0f57511]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb0f48de4]
/usr/lib/openoffice/program/../basis-link/program/libsfxli.so[0xb77c351b]
/usr/lib/openoffice/program/../basis-link/program/libsfxli.so[0xb77b87f6]
/usr/lib/openoffice/program/../basis-link/program/libsfxli.so[0xb77b9b9c]
/usr/lib/openoffice/program/../basis-link/program/libsfxli.so
(_ZN11SfxBindings7ExecuteEtPPK11SfxPoolItemttS3_+0x58)[0xb77b9da8]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb0e02be7]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb0e082a2]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb0dec9e6]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb0ecb18f]
/usr/lib/openoffice/program/../basis-link/program/libscli.so[0xb0f08947]
/usr/lib/openoffice/program/../basis-link/program/libvclli.so[0xb6b1a8a9]
/usr/lib/openoffice/program/../basis-link/program/libvclli.so[0xb6b1c63f]
/usr/lib/openoffice/basis3.1/program/libvclplug_genli.so[0xb46a0761]
/usr/lib/openoffice/basis3.1/program/libvclplug_genli.so
(_ZN11X11SalFrame14HandleKeyEventEP9XKeyEvent+0x61d)[0xb469a24d]
/usr/lib/openoffice/basis3.1/program/libvclplug_genli.so
(_ZN11X11SalFrame8DispatchEP7_XEvent+0x48d)[0xb46a04ad]
/usr/lib/openoffice/basis3.1/program/libvclplug_genli.so
(_ZN13SalX11Display8DispatchEP7_XEvent+0x267)[0xb46d6b07]
/usr/lib/openoffice/basis3.1/program/libvclplug_genli.so
(_ZN13SalX11Display5YieldEv+0x46)[0xb46d8466]
/usr/lib/openoffice/basis3.1/program/libvclplug_genli.so[0xb46d7efd]
/usr/lib/openoffice/basis3.1/program/libvclplug_genli.so(_ZN7SalXLib5YieldEbb
+0x29d)[0xb46d07ed]
/usr/lib/openoffice/basis3.1/program/libvclplug_genli.so
(_ZN14X11SalInstance5YieldEbb+0x37)[0xb46e01d7]
/usr/lib/openoffice/program/../basis-link/program/libvclli.so
(_ZN11Application5YieldEb+0x59)[0xb691f549]
/usr/lib/openoffice/program/../basis-link/program/libvclli.so
(_ZN11Application7ExecuteEv+0x3c)[0xb691f5cc]
/usr/lib/openoffice/program/../basis-link/program/libsofficeapp.so[0xb7e76b30]
/usr/lib/openoffice/program/../basis-link/program/libvclli.so[0xb6924508]
/usr/lib/openoffice/program/../basis-link/program/libvclli.so(_Z6SVMainv+0x35)
[0xb69245a5]
/usr/lib/openoffice/program/../basis-link/program/libsofficeapp.so(soffice_main
+0xac)[0xb7eadd9c]
/usr/lib/openoffice/program/soffice.bin(main+0x2c)[0x8048d6c]
/lib/i686/cmov/libc.so.6(__libc_start_main+0xe5)[0xb7be87a5]
/usr/lib/openoffice/program/soffice.bin[0x8048ca1]
======= Memory map: ========
08048000-0804a000 r-xp 00000000 fe:01 319554     /usr/lib/openoffice/program/
soffice.bin
0804a000-0804b000 rw-p 00001000 fe:01 319554     /usr/lib/openoffice/program/
soffice.bin
08e11000-0ad38000 rw-p 00000000 00:00 0          [heap]
ab7f7000-ab8b7000 rw-p 00000000 00:00 0 
abc97000-abcb8000 r--s 00000000 fe:01 189206     /usr/share/fonts/truetype/ttf-
liberation/LiberationSans-Bold.ttf
abcb8000-ac8c9000 rw-p 00000000 00:00 0 
ac8ca000-acdba000 rw-p 00000000 00:00 0 
acdbd000-acded000 rw-p 00000000 00:00 0 
acded000-acdf5000 r-xp 00000000 fe:01 344890     /usr/lib/openoffice/basis3.1/
program/libmcnttype.so
acdf5000-acdf6000 rw-p 00007000 fe:01 344890     /usr/lib/openoffice/basis3.1/
program/libmcnttype.so
acdf6000-ace0a000 r-xp 00000000 fe:01 344803     /usr/lib/openoffice/basis3.1/
program/liblnthli.so
ace0a000-ace0b000 rw-p 00014000 fe:01 344803     /usr/lib/openoffice/basis3.1/
program/liblnthli.so
ace0b000-ace4b000 r-xp 00000000 fe:01 288347     /usr/lib/libhunspell-1.2.so.0.0.0
ace4b000-ace4f000 rw-p 00040000 fe:01 288347     /usr/lib/libhunspell-1.2.so.0.0.0
ace50000-ace54000 r-xp 00000000 fe:01 288848     /usr/lib/libhyphen.so.0.2.0
ace54000-ace55000 rw-p 00003000 fe:01 288848     /usr/lib/libhyphen.so.0.2.0
ace55000-ace66000 r-xp 00000000 fe:01 344836     /usr/lib/openoffice/basis3.1/
program/libhyphenli.so
ace66000-ace67000 rw-p 00011000 fe:01 344836     /usr/lib/openoffice/basis3.1/
program/libhyphenli.so
ace67000-ace77000 r-xp 00000000 fe:01 344865     /usr/lib/openoffice/basis3.1/
program/libspellli.so
ace77000-ace78000 rw-p 00010000 fe:01 344865     /usr/lib/openoffice/basis3.1/
program/libspellli.so
ace78000-ace8f000 r-xp 00000000 fe:01 344773     /usr/lib/openoffice/basis3.1/
program/basprovli.uno.so
ace8f000-ace91000 rw-p 00016000 fe:01 344773     /usr/lib/openoffice/basis3.1/
program/basprovli.uno.so
ace91000-aced1000 r-xp 00000000 fe:01 344842     /usr/lib/openoffice/basis3.1/
program/ucptdoc1.uno.so
aced1000-aced3000 rw-p 00040000 fe:01 344842     /usr/lib/openoffice/basis3.1/
program/ucptdoc1.uno.so
aced3000-aced4000 rw-p 00000000 00:00 0 
aced4000-acef9000 r-xp 00000000 fe:01 344953     /usr/lib/openoffice/basis3.1/
program/libscriptframe.so
acef9000-acefb000 rw-p 00024000 fe:01 344953     /usr/lib/openoffice/basis3.1/
program/libscriptframe.so
acefb000-acf18000 r-xp 00000000 fe:01 344788     /usr/lib/openoffice/basis3.1/
program/fsstorage.uno.so
acf18000-acf1a000 rw-p 0001c000 fe:01 344788     /usr/lib/openoffice/basis3.1/
program/fsstorage.uno.so
acf1a000-acf2e000 r-xp 00000000 fe:01 344185     /usr/lib/openoffice/basis3.1/
program/vbaeventsli.uno.so
acf2e000-acf2f000 rw-p 00014000 fe:01 344185     /usr/lib/openoffice/basis3.1/
program/vbaeventsli.uno.so
acf2f000-acfbb000 r--s 00000000 fe:01 116061     /usr/share/fonts/truetype/ttf-
dejavu/DejaVuSans-Bold.ttf
acfbb000-ad0bc000 rw-p 00000000 00:00 0 
ad0bd000-ad0e5000 r-xp 00000000 fe:01 344771     /usr/lib/openoffice/basis3.1/
program/libucppkg1.so
ad0e5000-ad0e6000 rw-p 00027000 fe:01 344771     /usr/lib/openoffice/basis3.1/
program/libucppkg1.so
ad0e6000-ad132000 r-xp 00000000 fe:01 344815     /usr/lib/openoffice/basis3.1/
program/libxmlsecurity.so
ad132000-ad135000 rw-p 0004c000 fe:01 344815     /usr/lib/openoffice/basis3.1/
program/libxmlsecurity.so
ad135000-ad1d6000 rw-p 00000000 00:00 0 
ad1d6000-ad1d7000 ---p 00000000 00:00 0 
ad1d7000-ad9d7000 rw-p 00000000 00:00 0 
ad9d7000-ad9de000 r-xp 00000000 fe:00 549225     /lib/i686/cmov/librt-2.9.so
ad9de000-ad9df000 r--p 00006000 fe:00 549225     /lib/i686/cmov/librt-2.9.so
ad9df000-ad9e0000 rw-p 00007000 fe:00 549225     /lib/i686/cmov/librt-2.9.so
ad9e0000-ada17000 r-xp 00000000 fe:00 540955     /lib/libdbus-1.so.3.4.0
ada17000-ada18000 r--p 00037000 fe:00 540955     /lib/libdbus-1.so.3.4.0
ada18000-ada19000 rw-p 00038000 fe:00 540955     /lib/libdbus-1.so.3.4.0
ada19000-ada41000 r-xp 00000000 fe:01 289749     /usr/lib/libk5crypto.so.3.1
ada41000-ada42000 rw-p 00028000 fe:01 289749     /usr/lib/libk5crypto.so.3.1
ada42000-adae5000 r-xp 00000000 fe:01 289654     /usr/lib/libkrb5.so.3.3
adae5000-adaeb000 rw-p 000a2000 fe:01 289654     /usr/lib/libkrb5.so.3.3
adaeb000-adafa000 r-xp 00000000 fe:01 287712     /usr/lib/libavahi-client.so.3.2.5
adafa000-adafb000 rw-p 0000e000 fe:01 287712     /usr/lib/libavahi-client.so.3.2.5
adafb000-adb23000 r-xp 00000000 fe:01 286787     /usr/lib/libgssapi_krb5.so.2.2
adb23000-adb24000 rw-p 00028000 fe:01 286787     /usr/lib/libgssapi_krb5.so.2.2
adb24000-adb65000 r-xp 00000000 fe:01 287402     /usr/lib/libcups.so.2
adb65000-adb68000 r--p 00041000 fe:01 287402     /usr/lib/libcups.so.2
adb68000-adb69000 rw-p 00044000 fe:01 287402     /usr/lib/libcups.so.2
adb6a000-adb70000 r-xp 00000000 fe:01 417969     /usr/lib/ure/lib/proxyfac.uno.so
adb70000-adb71000 rw-p 00005000 fe:01 417969     /usr/lib/ure/lib/proxyfac.uno.so
adb71000-adbb1000 rw-p 00000000 00:00 0 
adbb3000-adc93000 rw-p 00000000 00:00 0 
adc95000-adc96000 r--s 00000000 fe:02 106570     /var/spool/openoffice/
uno_packages/cache/registry/
com.sun.star.comp.deployment.component.PackageRegistryBackend/Linux_x86_.rdb
adc96000-adc9e000 r--s 00000000 fe:02 106569     /var/spool/openoffice/
uno_packages/cache/registry/
com.sun.star.comp.deployment.component.PackageRegistryBackend/common_.rdb
adc9e000-adc9f000 r-xs 00000000 fe:03 4186129    /home/ab/.execooo1FWn4G (deleted)
adc9f000-adca0000 rw-s 00000000 fe:03 4186129    /home/ab/.execooo1FWn4G (deleted)
adca0000-add10000 rw-p 00000000 00:00 0 
add10000-add11000 r-xs 00000000 fe:03 4186128    /home/ab/.execooo5pg6Am (deleted)
add11000-add12000 rw-s 00000000 fe:03 4186128    /home/ab/.execooo5pg6Am (deleted)
add12000-add14000 r-xp 00000000 fe:00 540734     /lib/libkeyutils-1.2.so
add14000-add15000 rw-p 00001000 fe:00 540734     /lib/libkeyutils-1.2.so
add15000-add20000 r-xp 00000000 fe:01 287255     /usr/lib/libavahi-common.so.3.5.1
add20000-add21000 rw-p 0000a000 fe:01 287255     /usr/lib/libavahi-common.so.3.5.1
add21000-adda1000 rw-p 00000000 00:00 0 
adda1000-addfe000 r-xp 00000000 fe:01 344205     /usr/lib/openoffice/basis3.1/
program/libanalysisli.so
addfe000-ade00000 rw-p 0005d000 fe:01 344205     /usr/lib/openoffice/basis3.1/
program/libanalysisli.so
ade00000-ade46000 rw-p 00000000 00:00 0 
ade46000-adf00000 ---p 00000000 00:00 0 
adf00000-adf01000 r-xs 00000000 fe:03 4186127    /home/ab/.execoooNTu071 (deleted)
adf01000-adf07000 r-xp 00000000 fe:01 289705     /usr/lib/libkrb5support.so.0.1
adf07000-adf08000 rw-p 00005000 fe:01 289705     /usr/lib/libkrb5support.so.0.1
adf08000-adf0a000 r-xp 00000000 fe:00 540759     /lib/libcom_err.so.2.1
adf0a000-adf0b000 rw-p 00001000 fe:00 540759     /lib/libcom_err.so.2.1
adf0b000-adf27000 r-xp 00000000 fe:01 417968     /usr/lib/ure/lib/
introspection.uno.so
adf27000-adf28000 rw-p 0001c000 fe:01 417968     /usr/lib/ure/lib/
introspection.uno.so
adf28000-adf4c000 r--s 00000000 fe:01 189203     /usr/share/fonts/truetype/ttf-
liberation/LiberationSerif-Regular.ttf
adf4c000-adf4d000 ---p 00000000 00:00 0 
adf4d000-ae74d000 rw-p 00000000 00:00 0 
ae74d000-ae818000 r-xp 00000000 fe:01 344848     /usr/lib/openoffice/basis3.1/
program/liblocaledata_others.so
ae818000-ae840000 rw-p 000ca000 fe:01 344848     /usr/lib/openoffice/basis3.1/
program/liblocaledata_others.so
ae840000-ae863000 r-xp 00000000 fe:01 344433     /usr/lib/openoffice/basis3.1/
program/liblocaledata_es.so
ae863000-ae868000 rw-p 00023000 fe:01 344433     /usr/lib/openoffice/basis3.1/
program/liblocaledata_es.so
ae868000-ae9f7000 r-xp 00000000 fe:01 344180     /usr/lib/openoffice/basis3.1/
program/libvbaobjli.uno.so
ae9f7000-aea10000 rw-p 0018e000 fe:01 344180     /usr/lib/openoffice/basis3.1/
program/libvbaobjli.uno.so
aea10000-aea11000 rw-p 00000000 00:00 0 
aea11000-aea14000 r-xp 00000000 fe:01 288950     /usr/lib/libgpg-error.so.0.4.0
aea14000-aea15000 rw-p 00002000 fe:01 288950     /usr/lib/libgpg-error.so.0.4.0
aea15000-aea87000 r-xp 00000000 fe:01 287450     /usr/lib/libgcrypt.so.11.5.2
aea87000-aea8a000 rw-p 00072000 fe:01 287450     /usr/lib/libgcrypt.so.11.5.2
aea8a000-aea99000 r-xp 00000000 fe:01 287105     /usr/lib/libtasn1.so.3.1.6
aea99000-aea9a000 rw
Comment 1 ezdvf 2009-10-13 16:14:30 UTC
Created attachment 65344 [details]
spreadsheet with 115k rows
Comment 2 raal 2009-11-17 20:38:05 UTC
I can reproduce on ubuntu 9.10, OOo 3.1.1(ubuntu go-oo version).
OOo freeze, no crash on my system. 
@kohei: related to issue 30215?

Within version OOO320m4 (official ver.) paste operation works (65000 rows), but
I need save-close-open file to see filled rows. 
Comment 3 kyoshida 2009-11-17 21:33:45 UTC
no idea...   It doesn't crash on me, but I do see that some cells don't display
formula results (though the formulas are there).  Very interesting.
Comment 4 kyoshida 2009-11-17 21:35:11 UTC
Nevermind it just crashed on me ... :-/
Comment 5 kyoshida 2009-11-18 16:54:15 UTC
From raal's comment in desc3, the display issue also happens in the upstream
build also.  My gut feeling is that this is not related to the row limit
increase, based on raal's observation and my own hunch.  Of course a deeper
analysis may reveal otherwise...

Normally, issued related to the row limit increase cause poor performance, but
don't normally cause a crash.