Re: [users] Calc issue I've stumbled across

2007-07-31 Thread Eike Rathke
Hi Ken, On Tuesday, 2007-07-31 08:13:37 -0500, Ken Burnside wrote: > And when will that be out? http://wiki.services.openoffice.org/wiki/OOoRelease23 Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C

Re: [users] Calc issue I've stumbled across

2007-07-31 Thread Ken Burnside
And when will that be out? On 7/31/07, Eike Rathke <[EMAIL PROTECTED]> wrote: > Hi Ken, > > On Monday, 2007-07-30 10:25:47 -0500, Ken Burnside wrote: > > > Thank you, Eike. The formulation I gave would work in 2.2.3? > > No, it would work in 2.3 ;-) > > Eike > > -- > OOo/SO Calc core developer.

Re: [users] Calc issue I've stumbled across

2007-07-31 Thread Eike Rathke
Hi Ken, On Monday, 2007-07-30 10:25:47 -0500, Ken Burnside wrote: > Thank you, Eike. The formulation I gave would work in 2.2.3? No, it would work in 2.3 ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8

Re: [users] Calc issue I've stumbled across

2007-07-30 Thread Paul
> > Thank you, Eike. The formulation I gave would work in 2.2.3? That's good to hear... I suppose the only thing left is to close the issue that was created. /paul -- Processing Key for cracking HD DVD's: 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0 - Try Torpark; a small portable, op

Re: [users] Calc issue I've stumbled across

2007-07-30 Thread Ken Burnside
Thank you, Eike. The formulation I gave would work in 2.2.3? On 7/30/07, Eike Rathke <[EMAIL PROTECTED]> wrote: > Hi Paul, > > On Monday, 2007-07-30 08:41:22 +1200, Paul wrote: > > > > =IF(D14="",Blank,Action_Points) > > > > > > Which means that if cell D14 is empty, use the named range Blank to

Re: [users] Calc issue I've stumbled across

2007-07-30 Thread Eike Rathke
Hi Paul, On Monday, 2007-07-30 08:41:22 +1200, Paul wrote: > > =IF(D14="",Blank,Action_Points) > > > > Which means that if cell D14 is empty, use the named range Blank to > > populate this drop down list, else use the named range Action_Points. > > [...] > > > > Have you managed to get a similar

Re: [users] Calc issue I've stumbled across

2007-07-29 Thread Paul
> > Mr. Perry, thank you for the quick response. > > I appear to have been unclear. > > The original formula in Excel is: > > =IF(D14="",Blank,Action_Points) > > Which means that if cell D14 is empty, use the named range Blank to > populate this drop down list, else use the named range Action_Point

Re: [users] Calc issue I've stumbled across

2007-07-28 Thread Ken Burnside
Mr. Perry, thank you for the quick response. I appear to have been unclear. The original formula in Excel is: =IF(D14="",Blank,Action_Points) Which means that if cell D14 is empty, use the named range Blank to populate this drop down list, else use the named range Action_Points. (A further test

Re: [users] Calc issue I've stumbled across

2007-07-28 Thread S Perry
This must be frustrating for you. First, you should know that =IF(D15=""...) is not equal to =IF(D15=0...). The former may indeed evaluate to "0", but then again it may not, depending on whether you have formatted the cell as a number or text. You may be introducing some of these err

[users] Calc issue I've stumbled across

2007-07-28 Thread Ken Burnside
I use data validation to make my spreadsheets more idiot proof. I've found the feature in Data > Validity that does this, and for simple cases, it's good. However, I'm doing something that is apparently not yet implemented. I commonly use list validations in the format of: =IF(D15="",Blank,Acti