Re: Is there a way to simplify summing Writer table cells?

2017-07-14 Thread Girvin Herr
Steve, Thanks for your response. As you may have already seen from my response to Brian's reply, the solution to my problem is to use F2 rather than the sum icon from the toolbar. This produces and allows the formula =sum to be used and stick. The sum icon seems to convert such a formula to

Re: Is there a way to simplify summing Writer table cells?

2017-07-14 Thread Girvin Herr
On 07/14/2017 03:34 AM, Brian Barker wrote: Aha! I wasn't using the Sum icon, and it does indeed lead to a formula listing the cells in the range individually - instead of as a range. I don't see why this should be. This indeed makes subsequent dragging problematic. And I now see where

Re: Is there a way to simplify summing Writer table cells?

2017-07-14 Thread Brian Barker
At 17:38 13/07/2017 -0700, Girvin Herr wrote: On 07/13/2017 04:58 PM, Brian Barker wrote: At 15:11 13/07/2017 -0700, Girvin Herr wrote: I have a Writer document with about 50 rows in a table. At the bottom of the table, I want to sum the above column of cells in each row (a total). Currently,

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Steve Ahlers
Girvin (sorry about the misspelling), What formula do you get when you click and drag? That should give you the correct format that you can follow for other columns or in a spread sheet you can "copy" the result cell and "paste special" to other columns' result cells. Sent from my iPhone > On

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Girvin Herr
On 07/13/2017 04:58 PM, Brian Barker wrote: At 15:11 13/07/2017 -0700, Girvin Herr wrote: I have a Writer document with about 50 rows in a table. At the bottom of the table, I want to sum the above column of cells in each row (a total). Currently, the only way to add a new row or rows to

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Brian Barker
At 15:11 13/07/2017 -0700, Girvin Herr wrote: I have a Writer document with about 50 rows in a table. At the bottom of the table, I want to sum the above column of cells in each row (a total). Currently, the only way to add a new row or rows to this sum is to add the cell reference(s) (i.e. |)

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Girvin Herr
Steven, I just tried both, and with and without the <> and got the same results: **Expression is faulty **. Thanks for the help. Girvin On 07/13/2017 03:47 PM, Steven Ahlers wrote: Givin, Have you tried a "," or a ";" instead of a ":" ? Sent from my iPhone On Jul 13, 2017, at 3:11 PM,

Re: Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Steven Ahlers
Givin, Have you tried a "," or a ";" instead of a ":" ? Sent from my iPhone > On Jul 13, 2017, at 3:11 PM, Girvin Herr wrote: > > Greetings, > > I have a Writer document with about 50 rows in a table. At the bottom of the > table, I want to sum the above column of cells

Is there a way to simplify summing Writer table cells?

2017-07-13 Thread Girvin Herr
Greetings, I have a Writer document with about 50 rows in a table. At the bottom of the table, I want to sum the above column of cells in each row (a total). Currently, the only way to add a new row or rows to this sum is to add the cell reference(s) (i.e. |) to the long string of cell