https://issues.apache.org/bugzilla/show_bug.cgi?id=50244
--- Comment #12 from Yegor Kozlov <[email protected]> 2010-12-02 10:46:58 EST --- It is clear why the exception happens - the formula consists of a very long array that doesn't fit in the NameRecord and the array's tail is stored in a ContinueRecord. But I don't understand how this array was saved. I tried to reproduced it in Excel 2003 and Excel 2007 with no luck. The length of a Excel formula is limited to 1024 characters, Excel silently truncates longer strings. You can't input an array of 696 elements in the Name dialog. I tried to set such a long array via VBA but it didn't work either. Excel truncates long VBA arrays to 256 values. Try to run the attached vbs script that I used for testing. To apply the proposed fix we need a test case - either a sample file or a description how to create it. Without additional info this bug will stay as "needinfo" Regards, Yegor -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
