Open Office 2.4 Spreadsheet

[fldrice]

Well, I'm trying to do a small program on a spreadsheet "excel" but since I do not have excel because I get off the Open Office 2.4 and in this program that brings spreadsheat therefore gives me this error.

Err 512: Formula Overflow - Compiler: the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512. Interpreter: The total number of matrices that the formula creates exceeds 150. This includes basic functions that receive too large an array as a parameter (max. 0xFFFE, for example, 65,534 bytes).

I understand what he says, is that I have made more than 512 variables, and because I like to know if any of you from around here knows how to do that they can get more than 512 or if you can excel at putting more.
Oh if any of you ever happened, I would like and I would greatly appreciate, as if to tell me. And I looked at options and help and google but I could not find answers.

[Glenny]

Upgrade to version 3 maybe there does not give you that problem (?)

[Sam.D]

You really are using a formula with more than 512 symbols? Because otherwise, you may have some error in the formula, looking out there think that this error is thrown by different causes, such arrangements with ill-defined:

= (1, 2 | 4, 5, 6) 
Invalid array, the first row misses an element. This results in Err: 512 "Formula overflow." 

= (1, 2 +3) 
Invalid array, the second element is not a constant. This results in Err: 512 "Formula overflow."

If you really like your formula is so large as to skip that mistake I do not think you can increase the capacity of OpenOffice, as they say you could download and test version 3.0 to see that.

[fldrice]

I made this well, because despite being long, is divided into several parts. Which are almost identical to the first by changing a single value.

I do not know if explained, would be something more or less like this:

[A + B +1] + [A + B +2 ]+.....+[ A + B + N]

Because the problem remains that A and B, lead me make conditions.
Find a way to fix it but it's only temporary, I'm going to get the 3 and if not I will see what I can do in the excel.

And if all else fails, someone could recommend me a programming language in which it is not as difficult or rather tedious to do transactions. Actually I know very little or nothing of programming, so what am I doing in my spreadsheet program, but now that I daring this error because I think I'm going to have to give up on. I would like to know if there is a programming language in which some commands, whether or not to call them so, operations matrix related to default or having some mathematicians.

Well, thank you very much for the info and see what happens.

[fldrice]

= IF (M1.A24 = 1; M1.A25; 0) + IF (M1.B24 = 1; M1.B26; 0) + IF (M1.C24 = 1; M1.C27; 0) + IF (M1. D24 = 1; M1.D28; 0) + IF (M1.A53 = 1; M1.A54; 0) + IF (M1.B53 = 1; M1.B55; 0) + IF (M1.C53 = 1; M1 . C56; 0) + IF (M1.D53 = 1; M1.D57; 0) + IF (M1.A82 = 1; M1.A83; 0) + IF (M1.B82 = 1; M1.B84; 0) + IF (M1.C82 = 1; M1.C85; 0) + IF (M1.D82 = 1; M1.D86; 0) + IF (M1.A111 = 1; M1.A112; 0) + IF (M1. B111 = 1; M1.B113; 0) + IF (M1.C111 = 1; M1.C114; 0) + IF (M1.D111 = 1; M1.D115; 0) + IF (M1.A140 = 1; M1 . A141, 0) + IF (M1.B140 = 1; M1.B142; 0) + IF (M1.C140 = 1; M1.C143; 0) + IF (M1.D140 = 1; M1.D144; 0) + IF (M1.A169 = 1; M1.A170; 0) + IF (M1.B169 = 1; M1.B171; 0) + IF (M1.C169 = 1; M1.C172; 0) + IF (M1. D169 = 1; M1.D173; 0) + IF (M1.A198 = 1; M1.A199; 0) + IF (M1.B198 = 1; M1.B200; 0) + IF (M1.C198 = 1; M1 . C201; 0) + IF (M1.D198 = 1; M1.D202; 0) + IF (M1.A227 = 1; M1.A228; 0) + IF (M1.B227 = 1; M1.B229; 0) + IF (M1.C227 = 1; M1.C230; 0) + IF (M1.D227 = 1; M1.D231; 0) + IF (M1.A256 = 1; M1.A257; 0) + IF (M1. A256 = 1; M1.A257; 0) + IF (M1.B256 = 1; M1.B258; 0) + IF (M1.C256 = 1; M1.C259; 0) + IF (M1.D256 = 1; M1 . D260; 0)

That's = A2. M1 is the name of the path where there is the other data.
But it is just to 9 "members" when I need to do 342, that also only applies to the boxes of the matrix are (1.1) (2.2) (3.3) (4.4), etc.
It is the temporary solution that gave, as it was before but only for 1 "member" and to try to add the 2nd because the error that gave me 512.

Cells has no diagonals, there are more conditions yet, and therefore I will lie with the same problem.

I will read it in succession but not if it's something that directly help me with my problem.

[chroma]

Python is always praised for its ease. And they make programs of the interactive interpreter that "also serves as a calculator."

[fldrice]

hmmm, well I will deal with this that you say.

Thanks for info.