Tom Harper wrote:
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
You have to register to OpenOffice.org web site first.
This is a serious bug and an issue must be filled as soon is possible.
I'm glad to help you do it.
--
Manolis Christodoulou MD
[EMAIL PROTECTED]
http://mobi-doc.com
http://palmpowereddoctor.blogspot.com
For document attachments please prefer OASIS/ISO OpenDocument Format.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
