Accounting columnar worksheets

Using them, Making them , Finding them

Accounting columnar worksheets

Postby MikeCPA » Wed Jun 20, 2012 2:50 am

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
MikeCPA
 
Posts: 93
Joined: Sat Aug 30, 2008 5:26 am

Re: Accounting columnar worksheets

Postby Hagar Delest » Sat Jul 21, 2012 6:13 pm

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.0.5 on Xubuntu 21.04 and 7.0.5 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 29888
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Accounting columnar worksheets

Postby MikeCPA » Sun Jul 22, 2012 2:48 am

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
MikeCPA
 
Posts: 93
Joined: Sat Aug 30, 2008 5:26 am

Re: Accounting columnar worksheets

Postby Hagar Delest » Sun Jul 22, 2012 11:53 am

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.0.5 on Xubuntu 21.04 and 7.0.5 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 29888
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Accounting columnar worksheets

Postby MikeCPA » Sun Jul 22, 2012 7:06 pm

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
MikeCPA
 
Posts: 93
Joined: Sat Aug 30, 2008 5:26 am

Re: Accounting columnar worksheets

Postby RoryOF » Sun Jul 22, 2012 7:27 pm

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.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32846
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Templates

Who is online

Users browsing this forum: No registered users and 2 guests