-
Posts
297 -
Joined
-
Last visited
Profile Information
-
Gender
Male
Recent Profile Visitors
832 profile views
-
Ant Rhonda reacted to a post in a topic: Is it possible to snap objects according to distance
-
Aleksandr Novakov reacted to a post in a topic: Can't add nodes to curves with the pen tool
-
Affinity Publisher formula in tables
Greyfox replied to Greyfox's topic in Affinity on Desktop Questions (macOS and Windows)
Thanks Gary. That would be an option for some applications In this particular application there are a lot of individual, but similar, documents generated. Each document has one of a small number of custom format tables included. Each custom format table can be used with a number of documents that require the same cell references, but will have different values. So I have the custom format tables saved as assets. 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. At a later stage, after those values have been checked in the field, one or two may need to be updated. In this particular instance it would be extra work and document management to use Excel tables when I can simply open the .ppp file, change the one or two values, have the total updated automatically and then export the document. For this particular application it seems PagePlus X9 is the better tool to use, much as I now prefer Affinity Publisher for other work. -
Affinity Publisher formula in tables
Greyfox replied to Greyfox's topic in Affinity on Desktop Questions (macOS and Windows)
I have hundreds of .ppp files. As you would be aware, Affinity Publisher doesn't support them, so I keep PagePlus X9 installed so I can open them on an as needed basis and export as PDF so I can open in Affinity Publisher, so having to drop back to PagePlus for the odd job in my case isn't a problem. -
Affinity Publisher formula in tables
Greyfox replied to Greyfox's topic in Affinity on Desktop Questions (macOS and Windows)
I can do the spreadsheet tables in Excel since I have Office. That's not the point. 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. In Pageplus X9 it's just a matter of updating the particular cells and the totals are automatically recalculated. 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. 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. Another 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. 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. -
Affinity Publisher formula in tables
Greyfox replied to Greyfox's topic in Affinity on Desktop Questions (macOS and Windows)
OK, thanks for the response. I had hoped that there might have been something in that regard in a roadmap or in beta. Disappointing. For now, at least for this type of project, back to PagePlus X9. -
Yesterday I was working on a project in Affinity Publisher 1.9.2.1035 (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. 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. From 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. If any cell values are subsequently changed in AP, the calculated cells will then show an incorrect value. Coming from years of use of PagePlus this seems to be a significant step backwards, but perhaps things have changed since the posts I found. Can 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?
-
adi_cataleya reacted to a post in a topic: Designer b-splines and arc tool
-
Thanks for confirming. So unless there is some other way, I guess my question should now be "is there meant to be a way to constrain the brush stroke?", or perhaps "is it a function that has not ever been in Designer and needs to be the subject an improvement request, or was it present at some stage but no longer works, in which case maybe a bug report?"
-
Greyfox started following Canon 90D CR3 raw files exteremly slow to edit
-
Canon 90D CR3 raw files exteremly slow to edit
Greyfox replied to v1ktor's topic in Pre 1.10 Photo Bugs found on Windows
Hardware-accelerated GPU scheduling is "ON", also Affinity Photo, Designer and Publisher all set to High Graphics Performance -
Joachim_L reacted to a post in a topic: Affinity not printing square
-
Affinity not printing square
Greyfox replied to karlb1's topic in Affinity on Desktop Questions (macOS and Windows)
What happens if you select the "square object" before File->Print, and then select "Selection" for range in the print dialog. That should print the selection in the centre of the printer paper size. -
white border on print
Greyfox replied to Marvin Contreras's topic in Pre 1.10 Photo Bugs found on Windows
What are the pixel dimensions of your image, and what size is the photo paper?