[CC'd to Paul] In news:[EMAIL PROTECTED], Paul_B <[EMAIL PROTECTED]> typed: > On Tue, 21 Feb 2006 11:42:05 -0800, Paul Hubert wrote: > > > 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. > > > 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...). > > I'm no expert, but Write and Calc tables appear to be two > completely different entities. When you create a Write table you > should get a floating Table toolbar containing the Sum function. > Clicking that after you have some data entered will bring up the > likes of > > =sum(<A2>|<A3>|<A4>|<A5>) > > which is some very cumbersome formatting.
Yes, but the format: =sum(<A2:A5>) will work, as well. It's just that clicking the toolbar sum icon includes the long version. Another way to add formulas to a Writer table is to type the equals sign (=) or F2 key, and that will open a formula bar with a "f(x)" icon and a drop down list of formulas. Pick a formula and use the mouse to drag over the relevant areas. -- Bob Long --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
