To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114451 Issue #|114451 Summary|Raise the 512 token limit in OOo Calc formulas Component|Spreadsheet Version|OOO320m12 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|ghe
------- Additional comments from [email protected] Sat Sep 11 10:58:02 +0000 2010 ------- Hi, I'm working with very long formulas and I frequently bump into the 512 token limit in OOo Calc formulas, which raises the error "512". This limit seems somewhat arbitrary, and its value (512 tokens) did not change at least since OOo 2.3 (ie since 2007). The corresponding limit in MS Excel is in characters (ie not tokens): - Excel up to 2003 (ie in Excel 11 and earlier): 1024 characters - starting from Excel 2007 (ie in Excel 12 and 13): 8192 characters As a consequence, files created with Excel 2007 or 2010 and containing very long formulas do not open correctly in OOo: the formula will be cut after 512 tokens, raising an error. I attach an example of (admittedly useless) 8192 character long formula, to be pasted into A2 for instance. It works when it is pasted in an Excel cell, but will not work in Calc, because it has 7050 tokens. Now that we have 1 mega-rows in Calc files (which may seem useless to most users), would it be possible to also raise that limit to 8192 tokens (which will probably also seem useless to most users, but may be useful for some, and in any case enhances compatibility)? Thanks in advance, --ghe --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
