![]() ![]() There's a short article that gives a good overview of setting up a mail merge, here. Writer can pull the data out and insert it in the invoice document as needed. In that case, you just use a spreadsheet as the data base and a regular Writer document as the invoice/report. and the seagull logo are registered trademarks of The Apache. File type compatibility, cost (free), advanced features comparable to Excel, ability to save files to Microsoft native formats such as PPT and PPTX. Though the interface is a bit different than Microsoft Excel, it is easy to learn, and the price is right. tsv formats to move your existing sheets into Zoho Sheet easily. Apache and the Apache feather logos are trademarks of The Apache Software Foundation. Using OpenOffice Calc has been a very good experience overall. In more limited cases-like yours, I think-you can follow the same approach much more simply using a "mail merge". Zoho Sheet is a free, cloud-based spreadsheet tool that supports several file types, including Excel (.xls). In the general case, the data source would be a database and the formatted invoice would be a report generated from the database. You can do that for any item and you don't need to use the spreadsheet to manage the formatting. Now, to make an invoice for any item, you pull the data out from the desired row and arrange it and format it to give you the nice invoice. The rows of this data source make a table that is the "spreadsheet" listing all the items. Here's the idea: You have a data source, with each row holding all the data for one invoice item it sounds like you only need one item per invoice, which makes things a lot simpler. Please note that password-protected files cant be imported. Naturally, more power means more complexity, but it doesn't have to be a lot more complex. You can convert Microsoft Excel files or OpenOffice spreadsheet files into Google Sheets. What you've described is exactly the situation solved by a much more powerful approach than a typical spreadsheet. invoice them by the piece, but also supply them with a spreadsheet listing every job.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |