Although our site is standardize on everything Microsoft, I've downloaded and have been working with OO 2.0.1.
Recently, I tried =sum(above) in a currency Write table only to find the function was apparently unavailable. The table had two repeating heading rows. I exported to MS Word 2003 .doc format and Word had no difficulty inserting the =sum(above) and performing as I expected. Also, I tried using =sum(first-cell-in-range:last-cell-in-range) [I believe it was e3:e33 or somesuch] and that would only return a syntax error without indicating where the error was. Again, MS Word had no problems using exactly the same syntax. I checked out HELP but it didn't appear that there was any problem WITH my syntax! The only thing I could think of was that perhaps not every cell in the column was defined with numeric type Currency or that OO Write was having a problem with the repeating heading rows or that FUNCTIONS in OO Write tables had not been tested adequately, with, perhaps, more attention being paid to Calc (although I would have expected that the underlying code for Calc and Write Tables might have been shared...). ????
