Brian,
Is there a method of reporting this as a bug or something that should be
fixed?
Will the programers read this forum to track and issues that need fixing.
Cheer
Tom
On 12/10/2007, Tom Harper <[EMAIL PROTECTED]> wrote:
>
> 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
>
>
--
Tom Harper
Acoustic Consultant
email: [EMAIL PROTECTED]
