https://issues.apache.org/ooo/show_bug.cgi?id=114451
--- Comment #7 from ghe <[email protected]> --- > Please provide a real life example for this request. Do you want to see a formula that is longer than 512 tokens? Here is one: "=IF(NOT(AND(OR(ISBLANK(A3);ISNUMBER(A3+0);TRIM(A3)="A";TRIM(A3)="");OR(ISBLANK(B3);ISNUMBER(B3+0);TRIM(B3)="A";TRIM(B3)="");OR(ISBLANK(C3);ISNUMBER(C3+0);TRIM(C3)="A";TRIM(C3)="");OR(ISBLANK(D3);ISNUMBER(D3+0);TRIM(D3)="A";TRIM(D3)="");OR(ISBLANK(E3);ISNUMBER(E3+0);TRIM(E3)="A";TRIM(E3)="");OR(ISBLANK(F3);ISNUMBER(F3+0);TRIM(F3)="A";TRIM(F3)="");OR(ISBLANK(H3);ISNUMBER(H3+0);TRIM(H3)="A";TRIM(H3)="");OR(ISBLANK(I3);ISNUMBER(I3+0);TRIM(I3)="A";TRIM(I3)="");OR(ISBLANK(J3);ISNUMBER(J3+0);TRIM(J3)="A";TRIM(J3)="")));"?";IF(AND(OR(TRIM(A3)="";ISBLANK(A3));OR(TRIM(B3)="";ISBLANK(B3));OR(TRIM(C3)="";ISBLANK(C3));OR(TRIM(D3)="";ISBLANK(D3));OR(TRIM(E3)="";ISBLANK(E3));OR(TRIM(F3)="";ISBLANK(F3));OR(TRIM(H3)="";ISBLANK(H3));OR(TRIM(I3)="";ISBLANK(I3));OR(TRIM(J3)="";ISBLANK(J3)));"";IF(OR(TRIM(A3)="A";TRIM(B3)="A";TRIM(C3)="A";TRIM(D3)="A";TRIM(E3)="A";TRIM(F3)="A";TRIM(H3)="A";TRIM(I3)="A";TRIM(J3)="A");"A";(IF(OR(TRIM(A3)="";ISBLANK(A3));0;A3.5)+IF(OR(TRIM(B3)="";ISBLANK(B3));0;B3*2.5)+IF( OR(TRIM(C3)="";ISBLANK(C3));0;C3*3)+IF(OR(TRIM(D3)="";ISBLANK(D3));0;D3*9)+IF(OR(TRIM(E3)="";ISBLANK(E3));0;E3*3)+IF(OR(TRIM(F3)="";ISBLANK(F3));0;F3*6)+IF(OR(TRIM(H3)="";ISBLANK(H3));0;H3*7.5)+IF(OR(TRIM(I3)="";ISBLANK(I3));0;I3*8)+IF(OR(TRIM(J3)="";ISBLANK(J3));0;J3*7.5))/(IF(OR(TRIM(A3)="";ISBLANK(A3));0;1.5)+IF(OR(TRIM(B3)="";ISBLANK(B3));0;2.5)+IF(OR(TRIM(C3)="";ISBLANK(C3));0;3)+IF(OR(TRIM(D3)="";ISBLANK(D3));0;9)+IF(OR(TRIM(E3)="";ISBLANK(E3));0;3)+IF(OR(TRIM(F3)="";ISBLANK(F3));0;6)+IF(OR(TRIM(H3)="";ISBLANK(H3));0;7.5)+IF(OR(TRIM(I3)="";ISBLANK(I3));0;8)+IF(OR(TRIM(J3)="";ISBLANK(J3));0;7.5)))))" It is extracted from a "real life example" (I'm not allowed to put the file online). If this is not enough, please define "real life example". N.B.: Please do not reply that I could split this formula in two. I know very well that this can be done, but for a number of reasons, that would be too long to explain here, it is not a viable option. > Or use Excel. Well, that's a quite strange advice in an OpenOffice forum! > Without further information, this issue will be closed per QA rules. What specific Quality Assurance (!) rule do you refer to? I'm quite surprised that it takes so long (more than three years since my original post!) and that it is necessary to argument that much for a simple change on only one line in the OpenOffice code base: "#define MAXCODE 512" to "#define MAXCODE 8192" in compiler.hxx. As I wrote earlier this change may seem useless to most users (like the 1048576 rows), but may be useful for some, and in any case enhances compatibility (with Excel). -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
