Dear Alan,
I downloaded 2.3 and installed it and I am happy to report that the formulas
now convert Ok from excel to OOo. Works perfect as far as I have
investigated.
really happy that this forum works so well. I have done a short search of
the 2.3 manual and can't find any mention of the increased function of the {
brackets }.
Cheers
Tom
On 06/10/2007, Alan Lord <[EMAIL PROTECTED]> wrote:
>
> Tom Harper wrote:
> > Thanks for the info Joe
> >
> > I only have 2.2.1. I only just downloaded it a short while ago. So not
> sure
> > why it isn't latest version.
> >
>
> I'm unsure about your specific forumla but I have been using the {}
> array formula construct for some time in OOo (I am currently running the
> 2.2.0 Ubuntu Feisty release).
>
> Make sure you use the CTL+SHIFT+ENTER when you leave the formula cell.
> You can't type the curly braces in, they must be generated by the app
> when you leave the cell.
>
> Here's an example of a formula I use with named ranges in other sheets -
> It adds all cells in range that fit the criteria and present the result.
> The range grows and contracts as line items are added or removed.
>
>
> {=SUM((Single_SaleDate>April)*(Single_SaleDate<=May)*(Single_UK="Y")*(Single_Sales))}
>
> HTH
>
> Alan
>
> --
> The way out is open!
> http://www.theopensourcerer.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
Tom Harper
Acoustic Consultant - Manager
AnV Engineering Consultants
Reg: 53101544X
51 Hindhede Walk #10-06
Singapore 587975
t: +65 6462 0558
m: +65 9623 5730
email: [EMAIL PROTECTED]
