> -------- Originele bericht --------
> To: users@openoffice.org
> From: Manolis Christodoulou <[EMAIL PROTECTED]>
> Date: Mon, 15 Oct 2007 10:42:46 +0300
> Message-ID: <[EMAIL PROTECTED]>
> Mime-Version: 1.0
> Content-Type: multipart/mixed;
> boundary="------------020000040404020809020202"
> Subject: Re: Calc Bug with use of { brackets} in array Formulas
>
> Tom Harper wrote:
>> 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
>
>
Hi Tom,
The following example might contain a workaround to make a constant
array of pos and neg numbers:
{=IF({1;0;0;1;}-{0;1;1;0}>0;"+";"-")}
Regards, Erik
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
