You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/01/07 14:23:34 UTC
DO NOT REPLY [Bug 118735] New: matrix/vlookup formulars can freeze
oo
https://issues.apache.org/ooo/show_bug.cgi?id=118735
Bug #: 118735
Issue Type: DEFECT
Summary: matrix/vlookup formulars can freeze oo
Classification: Application
Product: Spreadsheet
Version: OOo 3.4 Beta
Platform: PC
OS/Version: All
Status: UNCONFIRMED
Severity: major
Priority: P5
Component: code
AssignedTo: spreadsheet@openoffice.org
ReportedBy: brinzing@openoffice.org
CC: ooo-issues@incubator.apache.org
Created attachment 77106
--> https://issues.apache.org/ooo/attachment.cgi?id=77106
matrix/vlookup formular demo
i found this bug in win32 aoo3.4 dev build revision 1226179
steps to reproduce:
- open attached file "test_performance_matrix.ods"
- change a value in column c
- if new value is not in column a (e.g. 0 or 2501)
oo will freeze
btw: lo 3.4.4 will not open the file at all
https://bugs.freedesktop.org/show_bug.cgi?id=44420
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
--- Comment #4 from brinzing <br...@openoffice.org> 2012-01-30 06:28:24 UTC ---
Created attachment 77179
--> https://issues.apache.org/ooo/attachment.cgi?id=77179
result_excel2003.gif
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
brinzing <br...@openoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |brinzing@openoffice.org
--- Comment #1 from brinzing <br...@openoffice.org> 2012-01-30 06:25:54 UTC ---
adding another sample document with only 500 rows.
aoo won't freeze now, but all values in columns F and G
will be set to #N/A, if an invalid entry in column c has
been entered (for example 0).
this is different from excel. excel sets #N/A only for
the row, where the inalvid entry has been entered.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
--- Comment #3 from brinzing <br...@openoffice.org> 2012-01-30 06:27:29 UTC ---
Created attachment 77178
--> https://issues.apache.org/ooo/attachment.cgi?id=77178
result_aoo34.gif
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |VERIFIED
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
Rob Weir <ro...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution| |FIXED
--- Comment #6 from Rob Weir <ro...@apache.org> 2012-02-02 15:41:30 UTC ---
Fixed in revision 1239673
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
--- Comment #7 from hdu@apache.org 2012-02-02 15:58:39 UTC ---
With "fixed in revision 1239673" I meant the stability problem of Calc freezing
is solved. The difference between Calc and Excel interpreting vlookup
differently should be treated as a separately.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
--- Comment #8 from brinzing <br...@openoffice.org> 2012-02-08 09:19:43 UTC ---
verified in rev 1240836 - aoo no longer frezzes
>The difference between Calc and Excel interpreting vlookup
>differently should be treated as a separately.
you are right, changing the current behaviour could
cause problems
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|VERIFIED |CLOSED
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
hdu@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |hdu@apache.org
Ever Confirmed|0 |1
--- Comment #5 from hdu@apache.org 2012-01-30 08:20:37 UTC ---
Great report and bugdocs, thanks!
Confirming as reproducible on a recent pre-AOO34 on Win.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118735] matrix/vlookup formulars can freeze oo
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118735
--- Comment #2 from brinzing <br...@openoffice.org> 2012-01-30 06:26:34 UTC ---
Created attachment 77177
--> https://issues.apache.org/ooo/attachment.cgi?id=77177
vlookup_500_rows.xls
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.