Search the Community
Showing results for tags 'excel'.
Found 12 results
-
The lack of the ability to insert formulas in a Publisher V1 table meant I had to return to Serif PagePlus (why does an 'upgrade' have fewer features than the original?). The advertised posiiblity of importing excel files into Publisher V2 seemed to fix this but I haven't been able to do this. The Help led me to believe that one should select the Open command from the File menu but when I do the File Open dialogue doesn't allow me to select a .xlsx file. I can drag and drop an .xlsx file from Windows Explorer but only the contents of the first cell are displayed in the Affinity document.
-
Hello, Someone knows if the tables in AP will allow applying simple formulas of numerical calculation (something similar to what Excel does or ID through plugins: http://www.dtptools.com/product.asp?id=atid&more=features). That would be great! Thank you- 8 replies
-
- 1
-
-
- tables
- calculation
- (and 2 more)
-
Hi there. I'm developing a newsletter / report in Affinity Publisher that involves producing charts in Excel and pasting them into the report. As I want to ensure proper printing quality once the output is exported as PDF, I'm pasting the charts in windows metafile or enhanced metafile, instead of in picture format (e.g. png / bmp). Problem is that quite randomly, Affinity decides to ignore certain elements of the chart (axis mostly). If I paste the object as a picture, the object comes up in full, so clearly Excel is exporting the information but it seems that it is the Affinity Publisher end, the one struggling to render the full set of elements. Screen capture of Excel: Screen capture of the object pasted in the Affinity Publisher document: Screen capture of the same object, now pasted as PNG (all the axis present): Any help, much appreciated. -
The copying content from Excel's multiple cells and tables is not working well. When following steps from help the content is not copied (paste special) to the Pulisher's table. When the table (from Excell 2016) is saved in older format e.g. Excel XLS 2003+ and then reopened in the Open Office, then copied into the Publisher -- everything is working properly. In case of Excel 2016+ it was possible to insert the content to only one cell. Does anyone have encountered this error? -
Hi folks, I suggest implementation with variable data from an excel or any office datasheet. I usually do event folders that need scheduling with constant editions in cases of changing time, day, speaker, title or photos. It´s extremely necessary that changing my datasheet automatically adjust my layout using variables by tag or other similar way. It´s relevant that interface doesn´t ask for manual insertion fields and the dialog box offer tags to drag and drop like into document, permitting applying styles into them with personalized adjusts. It´s just a suggestion that I´d love if happen! template_event_folder.xlsx
- 4 replies
-
- 1
-
-
- variable data
- data merge
- (and 4 more)
-
I would like to have these improvements and additional features: Tables: 1. Create tables from selected texts with tab stops. 2. Convert tables to continuous text. 3. Can share single cells at any time. (Helpful for complex tables and subsequent cell division changes) 4. Can change cell size by moving the dividing lines. Import (placing) of further text files: Word .docx, .doc Excel .xlsx, .xls The copying and pasting of the texts is only possible if you have a program with which you can open these files. Diagram tool (was there in PagePlus) Calendar tool (give it in PagePlus) Create QR code and EAN code Open Indesign and QuarkXpress and PagePlus files Export Indesign and QuarkXpress files -
Hi, I successfuly "Pasted special..." Excel table into Publisher. The table retained its text formating, color and other attributes. Text is also fully editable. BUT... it would br really great if "Paste Special" can convert it into Publisher table where we can continue to work on it.
-
Hi, Are there any plans to include an option to Place an EXCEL table in a Publisher document? If possible it should have an option to link to the EXCEL file so that if that file is modified in EXCEL the changes will also appear in the linked table in the Publisher document. -
Hi, I just tried pasting some data from Excel - 3 columns by 8 rows. I expected it to come in as a table. It actually came in as a text box with tabs. PagePlus X8 manages to paste it in as a table. Cheers, Ian
-
Please add the main functions from Excel! For example: Sum, Min, Max, Count, Average.
-
Program
nautvt posted a topic in Pre-V2 Archive of Affinity on Desktop Questions (macOS and Windows)
Hi, I'm not very advanced in programs like excel and stuff, but I'll need to design badges for around 600 people soon where I get lists of people in excel with their info distributed in different columns. I have used affinity designer for a basic design. For example, cel 1: "Naut", cel 2: "Netherlands", cel 3: "blue". With this info I would like the tekst:"Naut" at the top, a dutch flag at the bottom and a blue square in the middle. Is it possible to use affinity designer for this? -
I have to sometimes make tables in AI with data taken from Excel, and AI does a good job of taking Excel cell data and populating it in AI, given they are in the same visual format. What I mean is if I have 2 columns of Excel data and I create a text frame with tabs then they show up correctly in AI. I tried this in AD and it didn't do it. Just curious to see if this is on anyone's radar. Seems like a long shot I know but never hurts to ask!!
