Accounting columnar worksheets

Using them, Making them, Finding them
Post Reply
MikeCPA
Posts: 93
Joined: Sat Aug 30, 2008 5:26 am

Accounting columnar worksheets

Post by MikeCPA »

Does anyone have any experience using Writer with tables to prepare accounting worksheets?

I think the table functions will do enough math to handle the job.
I cannot find any templates for this.
I wonder if someone has invented this wheel already
I'm assuming I can link cells in one table to another table in another file?

Thanks
OOo 3.4.X on Ms Windows XP + win2kpro
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Accounting columnar worksheets

Post by Hagar Delest »

MikeCPA wrote:I'm assuming I can link cells in one table to another table in another file?
You cannot.
What a strange idea to make accounting in a Writer document!
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
MikeCPA
Posts: 93
Joined: Sat Aug 30, 2008 5:26 am

Re: Accounting columnar worksheets

Post by MikeCPA »

Hagar Delest wrote:
MikeCPA wrote:I'm assuming I can link cells in one table to another table in another file?
You cannot.
What a strange idea to make accounting in a Writer document!
Don't worry, the writer files would only handle the document work. An accounting "workpaper" is more document that accounting. Number crunching would take place in Calc or Base.
OOo 3.4.X on Ms Windows XP + win2kpro
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Accounting columnar worksheets

Post by Hagar Delest »

So you don't really need any maths in your Writer file.
have you checked the template web pages?
Never heard of this kind of templates here.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
MikeCPA
Posts: 93
Joined: Sat Aug 30, 2008 5:26 am

Re: Accounting columnar worksheets

Post by MikeCPA »

Hagar Delest wrote:So you don't really need any maths in your Writer file.
have you checked the template web pages?
Never heard of this kind of templates here.
Yes, I checked. I thought a table in Writer might do some light weight math, or link to a spreadsheet or database.
I'm just learning here.
OOo 3.4.X on Ms Windows XP + win2kpro
User avatar
RoryOF
Moderator
Posts: 34571
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Accounting columnar worksheets

Post by RoryOF »

There is an old posting (circa 2003) at
Calculating in OpenOffice.Org Text Documents
which might be helpful.

Also something else at
Using formulas in tables
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply