Inventory template question

[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?

[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?

[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.

[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.

[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.

[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.

[Villeroy]

Copy&Paste-Special as HTML