incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 119034] Spreadsheet freezes on attempted insert->names->define->delete
Date Thu, 08 Mar 2012 06:34:07 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119034

brinzing <brinzing@openoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |brinzing@openoffice.org
     Ever Confirmed|0                           |1

--- Comment #3 from brinzing <brinzing@openoffice.org> 2012-03-08 06:34:07 UTC ---
confirming with aoo4.3 rev 1296433

i am pretty sure the root cause are the 65535 formula's
which have to be recalculated after deleting the named ranges:
=LOOKUP(A2;UCDDECIMAL;UCDNAME)

What you can do is to use matrix formula's:
{=LOOKUP(A2:A65535;UCDDECIMAL;UCDNAME)}

to reduce the file size, try to use matrix formula's
for other columns too ;-)

-- 
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

Mime
View raw message