Page 1 of 1

Inventory template question

PostPosted: Fri Feb 10, 2017 2:54 am
by Grannykat
I have three (3) columns on the right side of my inventory sheet in which I enter cost, selling price, sold price. It would be a wonderful asset if each column kept a running total (sum). Can anyone tell me (in very simple terms) how to accomplish this?

Re: Inventory template question

PostPosted: Fri Feb 10, 2017 4:34 am
by robleyd
The attached spreadsheet should point you in the right direction. It simply adds the amount in the column on the left of current cell to the subtotal in the row above the current cell.

 Edit: My solution is for a spreadsheet and I just noticed this is in the Writer section. Is your inventory actually a Writer document? 

Re: Inventory template question

PostPosted: Mon Feb 13, 2017 4:10 am
by Grannykat
I suppose a spreadsheet would work. Is it possible to move it all from the inventory form to a spreadsheet without manually re-entering every item?. I have over 7.5k items.

Re: Inventory template question

PostPosted: Mon Feb 13, 2017 6:20 am
by RusselB
If your data is already in a table, then you can use the SUM function in a row of the table. The function can be entered using Table -> Function (F2)

If you want to go over to a spreadsheet, you should be able to just copy your data from the Writer document, then paste it into a Calc document.
Paste Special (Ctrl+Shift+V) might be a better idea than Paste (ctrl+v), especially if you are copying a formatted table into Calc.

Re: Inventory template question

PostPosted: Mon Feb 13, 2017 12:23 pm
by Villeroy
Having a spreadsheet with data and calculations...

menu:File>New>Database...
[X] Connect to existing database
Type: Spreadsheet
Specify the spreadsheet document
[X] Register the database
Save the database
Click the [Tables] section
Right-click the "database table" (it is just an alternative view on your spreadsheet data) and choose "Create Report..."
Follow the instructions.
The result is a Writer document with all the table data pulled from the spreadsheet. The Writer document is embedded in the database document.
The report is filled with table data every time you open it. After the spreadsheet document had been modified or exchanged completely, you should restart the office suite. Otherwise the changes won't be reflected in the database report. This is a draw back when using spreadsheets as data sources.

Re: Inventory template question

PostPosted: Tue Feb 14, 2017 2:04 am
by RusselB
@Villeroy: It's my understanding that the data is already in a Writer document and the OP was wondering about how to transfer the data to a spreadsheet.

Re: Inventory template question

PostPosted: Tue Feb 14, 2017 2:14 am
by Villeroy
Copy&Paste-Special as HTML