Ask Your Question

How can I create a nice invoice, drawing totals from separate spreadsheets? [closed]

asked 2013-04-17 20:20:53 +0100

TenLeftFingers gravatar image

updated 2020-08-02 17:21:17 +0100

Alex Kemp gravatar image

I have several spreadsheets and want to create a nice looking invoice template in Writer (or Calc) that can take it's values from individual cells in other spreadsheets.

I've read this: and it seems the only way to directly reference a cell is with the likes of this: ='file:///path/name.xls'#$SheetX.$A$1

Is there an easier/GUI way to reference the cell of a local .ods file and how can I feed that to a Writer file?

I've tried: Table -> Formula, and entering: 'file:///Users/jarlathreidy/Ja.xlsx'#$Sheet1.$E$3 But it just says, Expression is faulty

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-30 17:33:53.833936

1 Answer

Sort by » oldest newest most voted

answered 2013-04-18 15:36:14 +0100

oweng gravatar image

I think the instructions here will give you what you want. You basically just need to Edit > Paste Special... > DDE Link and then format the display of the linked entry.

edit flag offensive delete link more


Thank you, that's _exactly_ what I was looking for! God, I've spent so much time, thanks very much.

TenLeftFingers gravatar imageTenLeftFingers ( 2013-04-19 11:21:31 +0100 )edit

Question Tools


Asked: 2013-04-17 20:20:53 +0100

Seen: 247 times

Last updated: Apr 18 '13