Tuesday, 15 February 2011

spreadsheet - How Do I Update OpenOffice Calc Sheets With New Formulas and Formats -


I have created a spread sheet in the OpenOffice Cal, which has several sheets for each month. Some specific formulas and data are specified in the sheet in several months. Is there any easier way to go about modifying a formula and transferring it to all sheets? Or if there is a change in the format, is there a way to merge the sheet through some types of macros or some things?

I like the flexibility of spread sheets and calculate similarly for non-accounting data Otherwise, I may have an accounting software.

If your data is placed in a very regular manner, Paste it in and adjust it cell reference correctly.

However, for this type of flexibility (being able to make changes in one place and it displays all existing data) a database is usually required OpenOffice has a database component base, and the base Information can easily be imported into Calc if you have specific spreadsheet requirements The learning curve for the base is quite long, but if you often handle such data, then It can be meaningful.


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)