Once a table is pulled into the document, it is just a matter of filling in the values in one of the columns, and in PagePlus X9, those values are then automatically summed. So I have the custom format tables saved as assets. Each custom format table can be used with a number of documents that require the same cell references, but will have different values. Each document has one of a small number of custom format tables included. In this particular application there are a lot of individual, but similar, documents generated. That would be an option for some applications If you export the spreadsheet from Excel to PDF and then place – linked – the PDF into Publisher then every time you export the spreadsheet to PDF Publisher will automatically update the table, unless you have switched that option off in Preferences. Aside from having to keep and manage a whole bunch of Excel files, that is way more work than just updating the values in PagePlus X9. That means having to enter all of the values in calculator, or on paper, not just the ones that have changed, and then manually updating the total in the table itself, increasing the possibility of error.Īnother way would be by keeping the Excel files for all of the tables, updating them and then replacing the whole table in Affinity Publisher each time there is a change. In Affinity Publisher it seems I would have to change the values in the cells, then either recalculate the totals manually, either with pen and paper, or with a calculator app, and manually enter them in the tables. In Pageplus X9 it's just a matter of updating the particular cells and the totals are automatically recalculated. The particular application is one where from time to time one or more of the values in the tables has to be changed, resulting in different column totals. I can do the spreadsheet tables in Excel since I have Office. xlsx file, and then put that file into your Publisher file as a table. If any cell values are subsequently changed in AP, the calculated cells will then show an incorrect value.Ĭoming from years of use of PagePlus this seems to be a significant step backwards, but perhaps things have changed since the posts I found.Ĭan someone please tell me whether there is a way to have formula work in tables in the current version of AP, and if not whether there is any known plans to add that functionality?Īlternatively, you could just do the spreadsheet in a different application, such as LibreOffice Cals, export as a. After doing some searching in the forum it appears that at least early in its life, Affinity Publisher tables did not have the ability to use any formula.įrom my searches, I found references to AP being able to import Excel tables, but apparently cells with formula are imported only with the calculated value that was arrived at in Excel. (on Windows 10 Pro) that required a simple table where one column needed to have a total cell showing the sum of the column values and I was surprised to find the the formula "=sum(B3:B20)" didn't work. In the meantime, we invite you to have a read through our large number of previous articles at your leisure, or alternatively download our The Vibe: 101 Legal Snapshots e-book from Amazon here.Yesterday I was working on a project in Affinity Publisher 1. If you have a legal topic or query that you would like Affinity Lawyer to cover, or if you have any suggestions in relation to areas of interest, we would love to hear from you. If you are not yet subscribed, we invite you to subscribe to “The Vibe” here (scroll to the bottom of the page) so you can be the first to receive our new articles when they are published. We publish our legal news on our Facebook page and website, in addition to including our new articles in a newsletter sent to our subscribers. Our goal is to provide information and value to our clients and the community at large, whether it be by highlighting common legal issues or questions that we see occurring, discussing legislative changes which may have an impact on members of our community or just keeping important issues at the forefront of people’s minds such as the importance of having a Will and considering your Estate Planning. Home of Legal News / Publications – Affinity Lawyers ‘The Vibe’ newsletter provides regular updates on a variety of legal areas including property law, employment law, family law, wills & estate law including recent legislation changes, legal issues to consider, and general legal commentary to keep you informed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |