Sum comma-separated numbers in Writer

Discuss the word processor

Sum comma-separated numbers in Writer

Postby bfunk1987 » Thu Jun 20, 2019 10:36 pm

Hello My name is B really new here just got Open Office yesterday. Well im creating these documents to help with my inventory at work and I ran into a issue I cant quite figure out. So I've looked around in the survival guide and all but really didn't find a definitive answer(Probably cause its so many things in one) but anyway why not just ask then. I wrote most of it out in the attached image. Ill explain tho, the first column is the prices, the second column is the amount of items(which are several values) and the last column is the total for each row. So what I need to happen first is everything in the second column added together. Then multiply that by the first column which would go in the third column. Then everything in the last column added together in the final row. Is this possible?
 Edit: Subject changed: was Noob Question(maybe) -- MrProgrammer 
Attachments
Untitled.png
Open Office 4.1.6 on Widows 10
bfunk1987
 
Posts: 1
Joined: Thu Jun 20, 2019 7:58 pm

Re: Sum comma-separated numbers in Writer

Postby MrProgrammer » Fri Jun 21, 2019 12:27 am

bfunk1987 wrote:Ill explain tho, the first column is the prices, the second column is the amount of items(which are several values) and the last column is the total for each row. So what I need to happen first is everything in the second column added together. Then multiply that by the first column which would go in the third column. Then everything in the last column added together in the final row. Is this possible?
Writer has very limited ability to perform numeric calculations. It cannot add the comma-separated values in your second column. However you could select each cell in the second column and use Table → Convert → Text to Table → Separate at → Other → , → OK. Now you have the numbers in separate cells of a sub-table and can use a formula to add them, then multiply by the value in the first column. See Writer Guide: Working with Tables Using Spreadsheet Functions in a Table.
201906201722.odt
(14.18 KiB) Downloaded 34 times

You may find this task easier to accomplish this in Calc, which is designed to perform numeric calculations. If you have further questions about Calc, open a topic in that forum.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3812
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Sum comma-separated numbers in Writer

Postby Zizi64 » Fri Jun 21, 2019 6:26 am

In a few words: Wrong tool was chosen for a bad data structure.


Use the Calc, and type-in the data values into separate cells.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8225
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Writer

Who is online

Users browsing this forum: No registered users and 27 guests