SoCreative Posted October 2, 2024 Posted October 2, 2024 Apologies if already resolved. I'm running into an issue with tables. Why is the last row so large and how do I format it? Quote
Hangman Posted October 2, 2024 Posted October 2, 2024 Hi @SalmiArt and welcome to the forums, It looks like the last row contains merged cells, so you may (or may not) want to unmerge them by selecting the cell and then clicking Separate Cells in the context toolbar... Depending on whether the cell/s have any formatting, you should be able to reduce the height of the last row but if not can you upload the .xlsx file so we can look at what is going on... Quote Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
walt.farrell Posted October 2, 2024 Posted October 2, 2024 10 hours ago, SalmiArt said: Why is the last row so large Does it contain rotated text? Quote -- Walt Designer, Photo, and Publisher V1 and V2 at latest retail and beta releases PC: Desktop: Windows 11 Pro 23H2, 64GB memory, AMD Ryzen 9 5900 12-Core @ 3.00 GHz, NVIDIA GeForce RTX 3090 Laptop: Windows 11 Pro 23H2, 32GB memory, Intel Core i7-10750H @ 2.60GHz, Intel UHD Graphics Comet Lake GT2 and NVIDIA GeForce RTX 3070 Laptop GPU. Laptop 2: Windows 11 Pro 24H2, 16GB memory, Snapdragon(R) X Elite - X1E80100 - Qualcomm(R) Oryon(TM) 12 Core CPU 4.01 GHz, Qualcomm(R) Adreno(TM) X1-85 GPU iPad: iPad Pro M1, 12.9": iPadOS 18.3.1, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.0.1
Hangman Posted October 2, 2024 Posted October 2, 2024 3 minutes ago, walt.farrell said: Does it contain rotated text? I'm guessing by the orientation of the caret in the screenshot that it doesn't... Assuming that actually is the caret... Quote Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
SoCreative Posted October 2, 2024 Author Posted October 2, 2024 I was able to create a video. First time using tables in Publisher. I don't understand what's going on. I'll try building a new table next. Recording 2024-10-02 084202.mp4 Quote
Hangman Posted October 2, 2024 Posted October 2, 2024 Hi @SalmiArt, Many thanks for the screen recording... It would be really helpful if you could upload the Publisher file itself, just the page containing the table is fine so we can figure out what is going on... Quote Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
SoCreative Posted October 2, 2024 Author Posted October 2, 2024 Sure, this is after deleting the cell content from placing an .xlsx file. Is it picking up something wonky from that? table.afpub Quote
Hangman Posted October 2, 2024 Posted October 2, 2024 Hi @SalmiArt, Going back to @walt.farrell question above, was any of the text in the source .xlsx file rotated in Excel? Are you in a position to upload the original Excel file? Quote Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
SoCreative Posted October 2, 2024 Author Posted October 2, 2024 No, same format as the gray cells above. Sorry, not permitted to upload the original Excel file. Quote
Hangman Posted October 2, 2024 Posted October 2, 2024 55 minutes ago, SalmiArt said: No, same format as the gray cells above. Sorry, not permitted to upload the original Excel file. Thanks for confirming and no problem I completely understand you can't upload the source Excel file... There is something very odd with cell C35 in as much as the text caret can appear at both the top and bottom of that cell which shouldn't be possible... What originally appeared in that particular cell in the Excel file? table.mp4 Quote Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
Staff Pauls Posted October 2, 2024 Staff Posted October 2, 2024 If you could remove the sensitive data from the spreadsheet we may be able to work out what is causing the issue if we had the xlsx file Quote
SoCreative Posted October 2, 2024 Author Posted October 2, 2024 OK, here's a copy of the file with the text removed. table-nodata.xlsx Quote
Hangman Posted October 3, 2024 Posted October 3, 2024 Hi @SalmiArt, Many thanks for the file... The problem is caused by the hidden columns in the original Excel file... If you unhide columns D to G, resave and place the Excel file in Publisher you can format the cells without issue... The screen recording shows the original file on Page 1 and the version with columns D to G unhidden on Page 2... I would consider this a bug relating to how Publisher handles worksheets with hidden columns or rows... Table.mp4 SoCreative 1 Quote Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
Staff Pauls Posted October 3, 2024 Staff Posted October 3, 2024 I think its the fact the merged rows extend into the hidden columns which is confusing the app but definitely tidying those columns up will improve the import Quote
Hangman Posted October 3, 2024 Posted October 3, 2024 3 minutes ago, Pauls said: I think its the fact the merged rows extend into the hidden columns which is confusing the app but definitely tidying those columns up will improve the import It would be nice if Publisher could unhide hidden columns and rows but maybe that is outside the scope of the Table tool... What is odd about this is even once the cells are unmerged, why does the bottom row constantly expand in height? There is no way of knowing how the unmerge affects the hidden columns or even if the hidden columns form part of the imported Excel file... Quote Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 MacBook Pro M3 Max, 36 GB Unified Memory, macOS Sonoma 14.6.1, Magic Mouse HP ENVY x360, 8 GB RAM, AMD Ryzen 5 2500U, Windows 10 Home, Logitech Mouse
Staff Pauls Posted October 3, 2024 Staff Posted October 3, 2024 perhaps we should support hidden rows,columns - I'll mention it in the report Hangman 1 Quote
SoCreative Posted October 3, 2024 Author Posted October 3, 2024 Thank you all! I noticed as well, when I saved the Excel file with content as a text file, extra info showed up. I wasn't familiar with the hidden rows, columns feature in Excel. Hangman 1 Quote
Staff Affinity Info Bot Posted November 1, 2024 Staff Posted November 1, 2024 The issue "excel import - tricky situation with merged cells and hidden columns possibly" (REF: AF-4456) has been fixed by the developers in the latest beta build (2.6.0.2831). The fix is planned for inclusion in the next customer release. Customer beta builds are announced here and you can participate by following these instructions. If you still experience this problem once you are using that build version (or later) please reply to this thread including @Affinity Info Bot to notify us. SoCreative 1 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.