Hi all,
This is a follow up from a previous mail where we solved a problem to do
with array formulas in Calc using brackets to contain Constants eg
{1;2;3;4...}I have now discovered that the values in the brackets must be +ve values as - ve values give a 512 or 520 error. You can work around it by putting the values in a row and then referencing the row of the spreadsheet in the array formula. However, this is messy and means that the formula is more susceptible to error from other cell changes. I have attached a sample spreadsheet with the subject formulas in it. Does anyone have a bug fix for this. Regards, Tom Harper Acoustic Consultant
Sample Array Calc.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
