Ask Your Question
0

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 2013-04-18 15:37:30 +0100

oweng 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: http://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=3294 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
2

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

Comments

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

Stats

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

Seen: 191 times

Last updated: Apr 18 '13