[users] recovering corrupt .odb databases
Hi, I've got a .odb database that was used on a samba share with OpenOffice.org version 3.2.1 and when i try to open the file i get the Filter selection window. After digging around on the net i unziped the .odb file and saw errors that the database/backup file couldn't be opened (it was zero length). I removed the empty backup file and re-zipped the .odb file. I can now open the file, but when i click on 'Tables' or any of the Forms i get: The connection to the data source fish could not be established SQL Status: S1000 Error code: -40 General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException: o:/OOO320/src/package/source/xstor/xstorage.cxx: :3331; I've tried the hsqldb command line tool on the database and I can connect to it and e.g. \dt shows the right tables, but: sql \d Suppliers Error at 'stdin' line 4: \d Suppliers Failed to get metadata from database. Cause: java.sql.SQLException: Table not found in statement [SELECT * FROM Suppliers] Does anyone know any way to recover from this? btw: running strings on the data file shows reasonable content, and strings | wc -l compared to an older version shows that the newer version has more content, so it dosn't look like the data has been truncated. P.S. There is a commercial product called Kernel for Base from nucleus technologies that claims to be able to fix things like this, does anyone know if it actually works? attachment: jasper.vcf signature.asc Description: OpenPGP digital signature
[users] Sum values on IF
I have a spread sheet with lots of color values: Blue, White, Red, Orange, Gray, etc What Im wanting to do is have a cell that keeps a total of how many of each: Blue = 52, White = 2 etc I was using something like IF(C2=Red, 1)+IF(C3=Red, 1)+etc but that obviously gets crazy after a few rows. How can this be done faster? Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Sum values on IF
Wade Smart wrote: I have a spread sheet with lots of color values: Blue, White, Red, Orange, Gray, etc What Im wanting to do is have a cell that keeps a total of how many of each: Blue = 52, White = 2 etc I was using something like IF(C2=Red, 1)+IF(C3=Red, 1)+etc but that obviously gets crazy after a few rows. How can this be done faster? Wade Oh.. I got to thinking about summing and I found count which pointed to countif: =COUNTIF(C2:C43, Green) Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] get values to the right
I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] function as cell reference
I want the average of all the non-empty cells in a column 'c' starting at row 3. I tried: =AVERAGE(C3:c$(count(C3:C51)+3)) I'm sure it is simple. I need to make c$(count(C3:C51)+3) a cell reference. 'c15' as a non-formula, count(C3:C51)+3 = 15. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org no. =RIGHT(TEXT(C2,#),4) C2 = .. (last six digits) 0/1981 the above function produces 9736 Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 12:54:14 -0500 Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave no. =RIGHT(TEXT(C2,#),4) C2 = .. (last six digits) 0/1981 the above function produces 9736 Wade Please provide more information about the contents of cell C2. Your email header suggests you may be running some flavour of Linux. Are you using the OOo standard edition from the OOo website, or a distro supplied edition? I cannot replicate your results. If I simply enter 0/1981 in cell C2 my suggestion does not work, because Calc appears to treat the contents of cell C2 as text. In which case your original formula: =RIGHT(C2;4) for the OOo standard edition or =RIGHT(C2,4) for the Go-OO/Novel edition should work. Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
Original Message From: Dave Barton d...@tasit.net To: users@openoffice.org Date: Sun, 01 Aug 2010 05:10:14 +1000 Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 12:54:14 -0500 Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave no. =RIGHT(TEXT(C2,#),4) C2 = .. (last six digits) 0/1981 the above function produces 9736 Wade Please provide more information about the contents of cell C2. Your email header suggests you may be running some flavour of Linux. Are you using the OOo standard edition from the OOo website, or a distro supplied edition? I cannot replicate your results. If I simply enter 0/1981 in cell C2 my suggestion does not work, because Calc appears to treat the contents of cell C2 as text. In which case your original formula: =RIGHT(C2;4) for the OOo standard edition or =RIGHT(C2,4) for the Go-OO/Novel edition should work. Dave I have now replicated your results by changing the contents of cell C2 to a date (sometime in 1981), not a product code number as indicated in your original email. Could it be that Calc is translating what you perceive as as a product code into a date? Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
Dave Barton wrote: Original Message From: Dave Barton d...@tasit.net To: users@openoffice.org Date: Sun, 01 Aug 2010 05:10:14 +1000 Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 12:54:14 -0500 Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave no. =RIGHT(TEXT(C2,#),4) C2 = .. (last six digits) 0/1981 the above function produces 9736 Wade Please provide more information about the contents of cell C2. Your email header suggests you may be running some flavour of Linux. Are you using the OOo standard edition from the OOo website, or a distro supplied edition? I cannot replicate your results. If I simply enter 0/1981 in cell C2 my suggestion does not work, because Calc appears to treat the contents of cell C2 as text. In which case your original formula: =RIGHT(C2;4) for the OOo standard edition or =RIGHT(C2,4) for the Go-OO/Novel edition should work. Dave I have now replicated your results by changing the contents of cell C2 to a date (sometime in 1981), not a product code number as indicated in your original email. Could it be that Calc is translating what you perceive as as a product code into a date? Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Im on Ubuntu 9.04, OO 3.0.1, OOO300m15 Build:9379. If I put this number into C2 and run it I get 1981. Cell C2 = 2U915/ELEPVANISV0/1981 It might be taken for a date. Would the RIGHT() function not work on a date? Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
On 7/31/2010 10:54 AM, Wade Smart wrote: Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org no. =RIGHT(TEXT(C2,#),4) C2 = .. (last six digits) 0/1981 the above function produces 9736 Wade I think your problem stems from the way dates are stored in a cell. The actual contents of a cell containing is a real number, only just formatted to look like a date. The number zero in a cell formatted to a date will have the date 12/30/1899. Any date after that is internalized by the number of days since that zero date. I hope this provides you with an avenue to explore to obtain your desired result. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
JOE Conner wrote: On 7/31/2010 10:54 AM, Wade Smart wrote: Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org no. =RIGHT(TEXT(C2,#),4) C2 = .. (last six digits) 0/1981 the above function produces 9736 Wade I think your problem stems from the way dates are stored in a cell. The actual contents of a cell containing is a real number, only just formatted to look like a date. The number zero in a cell formatted to a date will have the date 12/30/1899. Any date after that is internalized by the number of days since that zero date. I hope this provides you with an avenue to explore to obtain your desired result. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org You fingered it Joe. I checked the column and its formated as date. I copied the number over to a new column formatted as text and it works great. Question: how do you reformat as text without loosing all the data? Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] function as cell reference
On 07/31/10 13:09, James wrote: I want the average of all the non-empty cells in a column 'c' starting at row 3. I tried: =AVERAGE(C3:c$(count(C3:C51)+3)) I'm sure it is simple. I need to make c$(count(C3:C51)+3) a cell reference. 'c15' as a non-formula, count(C3:C51)+3 = 15. Found the solution: *=AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3)))*
Re: [users] get values to the right
Wade Smart wrote: You fingered it Joe. I checked the column and its formated as date. I copied the number over to a new column formatted as text and it works great. Question: how do you reformat as text without loosing all the data? Select the cells, 'Copy', reformat cells as desired, 'Paste Special' uncheck all but 'Text'? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: error con insercion de videos
On 07/31/2010 12:26 PM, Nathalie Colina wrote: buenas! tengo una presentacion hecha en la version 3.2.0 que trae ubuntu 10.04, la cual tiene insertados algunos videos, al intentar reproducirla en la version 3.2.1 descargada de la pagina de OpenOffice.org, no muestra, ni reproduce los mismos... ademas de eso intente volverlos a insertar por medio del menú correspondiente (insertar - video y sonido) y me da un menjase de formato no compatible... probe con .ogg, .avi, .flv, .mp4 no se si falta algun complemento de java o de codecs o algo que no permite verlos ?o si tiene algo que ver con el hecho de haber sido instalada aparte y no por repositorios, no se si pasa en otros casos porq es la primera vez q hago esta prueba... gracias de antemano! good! I have a presentation made in the 3.2.0 version that brings ubuntu 10.04, which has inserted some videos, when you try to reproduce it 3.2.1 version downloaded from the OpenOffice.org page does not show, nor plays the same ... Besides that and try to re-enter through the menu for (insert - sound and video) and gives me a menjar format not compatible with the probe ogg,. avi,. flv,. mp4 not add any missing codecs or java or something that does not allow them? or if you have something to do with the fact of having been installed separately rather than repositories, not if it happens in other cases is the first time porq q I do this test ... === The difference is the at the Ubuntu (go-oo/novell) version uses the gstreamer plugins for sound video. For reasons still unknown, the standard OOo version does not requires that you install an antiquated jmf plugin instead. It's been awhile since I've experimented with jmf, but my old 2007 post might be of help: http://www.openoffice.org/servlets/ReadMsg?list=usersmsgNo=168915 [update w/MP3] Re: OOffice and sound in Impress - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] function as cell reference
2010/7/31 James bjloc...@lockie.ca: On 07/31/10 13:09, James wrote: I want the average of all the non-empty cells in a column 'c' starting at row 3. I tried: =AVERAGE(C3:c$(count(C3:C51)+3)) I'm sure it is simple. I need to make c$(count(C3:C51)+3) a cell reference. 'c15' as a non-formula, count(C3:C51)+3 = 15. Found the solution: *=AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3)))* I have to say that I really don't understand what you are doing here and why. I thought that you wanted to calculate the average value of all the (non empty) cells in column C starting at C3. That's obviously =AVERAGE(C3:C65536). Your formula, =AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3))), if COUNT(C3:C51)+3) = 15, will calculate =AVERAGE(C3:C15), which is not the whole C column. Also, the size of the range will change if you change something in C3:C51. What are you actually trying to accomplish here? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 14:47:07 -0500 Dave Barton wrote: Original Message From: Dave Barton d...@tasit.net To: users@openoffice.org Date: Sun, 01 Aug 2010 05:10:14 +1000 Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 12:54:14 -0500 Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave no. =RIGHT(TEXT(C2,#),4) C2 = .. (last six digits) 0/1981 the above function produces 9736 Wade Please provide more information about the contents of cell C2. Your email header suggests you may be running some flavour of Linux. Are you using the OOo standard edition from the OOo website, or a distro supplied edition? I cannot replicate your results. If I simply enter 0/1981 in cell C2 my suggestion does not work, because Calc appears to treat the contents of cell C2 as text. In which case your original formula: =RIGHT(C2;4) for the OOo standard edition or =RIGHT(C2,4) for the Go-OO/Novel edition should work. Dave I have now replicated your results by changing the contents of cell C2 to a date (sometime in 1981), not a product code number as indicated in your original email. Could it be that Calc is translating what you perceive as as a product code into a date? Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Im on Ubuntu 9.04, OO 3.0.1, OOO300m15 Build:9379. If I put this number into C2 and run it I get 1981. Cell C2 = 2U915/ELEPVANISV0/1981 It might be taken for a date. Would the RIGHT() function not work on a date? Wade No the right function will not work on a date. See Joe Connor's reply for the explanation. Unless there is good reason not to, I suggest formatting your product code cells as text. This will prevent Calc from interpreting them as a date. Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] get values to the right
Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 14:47:07 -0500 Dave Barton wrote: Original Message From: Dave Barton d...@tasit.net To: users@openoffice.org Date: Sun, 01 Aug 2010 05:10:14 +1000 Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 12:54:14 -0500 Dave Barton wrote: Original Message From: Wade Smart w...@wadesmart.com To: users@openoffice.org Date: Sat, 31 Jul 2010 10:46:42 -0500 I need to get the product code from a numeric string. I tried RIGHT(C2,4) but apparently this only works with letters and not numbers. Wade Does =RIGHT(TEXT(C2,#),4) do what you want? Dave no. =RIGHT(TEXT(C2,#),4) C2 = .. (last six digits) 0/1981 the above function produces 9736 Wade Please provide more information about the contents of cell C2. Your email header suggests you may be running some flavour of Linux. Are you using the OOo standard edition from the OOo website, or a distro supplied edition? I cannot replicate your results. If I simply enter 0/1981 in cell C2 my suggestion does not work, because Calc appears to treat the contents of cell C2 as text. In which case your original formula: =RIGHT(C2;4) for the OOo standard edition or =RIGHT(C2,4) for the Go-OO/Novel edition should work. Dave I have now replicated your results by changing the contents of cell C2 to a date (sometime in 1981), not a product code number as indicated in your original email. Could it be that Calc is translating what you perceive as as a product code into a date? Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Im on Ubuntu 9.04, OO 3.0.1, OOO300m15 Build:9379. If I put this number into C2 and run it I get 1981. Cell C2 = 2U915/ELEPVANISV0/1981 It might be taken for a date. Would the RIGHT() function not work on a date? Wade No the right function will not work on a date. See Joe Connor's reply for the explanation. Unless there is good reason not to, I suggest formatting your product code cells as text. This will prevent Calc from interpreting them as a date. Dave - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org The notes I have say this column was originally formated to number. I changed it to Text and its working now. Thanks Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] function as cell reference
On 07/31/10 17:26, Johnny Rosenberg wrote: 2010/7/31 James bjloc...@lockie.ca: On 07/31/10 13:09, James wrote: I want the average of all the non-empty cells in a column 'c' starting at row 3. I tried: =AVERAGE(C3:c$(count(C3:C51)+3)) I'm sure it is simple. I need to make c$(count(C3:C51)+3) a cell reference. 'c15' as a non-formula, count(C3:C51)+3 = 15. Found the solution: *=AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3)))* I have to say that I really don't understand what you are doing here and why. I thought that you wanted to calculate the average value of all the (non empty) cells in column C starting at C3. That's obviously =AVERAGE(C3:C65536). Your formula, =AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3))), if COUNT(C3:C51)+3) = 15, will calculate =AVERAGE(C3:C15), which is not the whole C column. Also, the size of the range will change if you change something in C3:C51. What are you actually trying to accomplish here? 51 is an arbitrary row. The =average function seems to treat empty cells as 0. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] function as cell reference
James wrote: On 07/31/10 17:26, Johnny Rosenberg wrote: 2010/7/31 James bjloc...@lockie.ca: On 07/31/10 13:09, James wrote: I want the average of all the non-empty cells in a column 'c' starting at row 3. I tried: =AVERAGE(C3:c$(count(C3:C51)+3)) I'm sure it is simple. I need to make c$(count(C3:C51)+3) a cell reference. 'c15' as a non-formula, count(C3:C51)+3 = 15. Found the solution: *=AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3)))* I have to say that I really don't understand what you are doing here and why. I thought that you wanted to calculate the average value of all the (non empty) cells in column C starting at C3. That's obviously =AVERAGE(C3:C65536). Your formula, =AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3))), if COUNT(C3:C51)+3) = 15, will calculate =AVERAGE(C3:C15), which is not the whole C column. Also, the size of the range will change if you change something in C3:C51. What are you actually trying to accomplish here? 51 is an arbitrary row. The =average function seems to treat empty cells as 0. ??? I just did a check on this, and the average function does NOT treat empty cells as 0. I entered the following in column A, starting in row 1: 2, 2, blank, blank, 2, 2. Then I entered the function =average(A1:A6), and the answer was 2, as expected. It would not have been 2 if the function treated blank cells as zeros.
Re: [users] function as cell reference
On 07/31/10 19:50, Richard Detwiler wrote: James wrote: On 07/31/10 17:26, Johnny Rosenberg wrote: 2010/7/31 James bjloc...@lockie.ca: On 07/31/10 13:09, James wrote: I want the average of all the non-empty cells in a column 'c' starting at row 3. I tried: =AVERAGE(C3:c$(count(C3:C51)+3)) I'm sure it is simple. I need to make c$(count(C3:C51)+3) a cell reference. 'c15' as a non-formula, count(C3:C51)+3 = 15. Found the solution: *=AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3)))* I have to say that I really don't understand what you are doing here and why. I thought that you wanted to calculate the average value of all the (non empty) cells in column C starting at C3. That's obviously =AVERAGE(C3:C65536). Your formula, =AVERAGE(C3:INDIRECT(c(COUNT(C3:C51)+3))), if COUNT(C3:C51)+3) = 15, will calculate =AVERAGE(C3:C15), which is not the whole C column. Also, the size of the range will change if you change something in C3:C51. What are you actually trying to accomplish here? 51 is an arbitrary row. The =average function seems to treat empty cells as 0. ??? I just did a check on this, and the average function does NOT treat empty cells as 0. I entered the following in column A, starting in row 1: 2, 2, blank, blank, 2, 2. Then I entered the function =average(A1:A6), and the answer was 2, as expected. It would not have been 2 if the function treated blank cells as zeros. Well it did but I recompiled it and now it doesn't. That's simpler. :-) Thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org