leminilab Posted November 15, 2020 Share Posted November 15, 2020 Hi, Very excited by the data merge function! While testing it (I'm a PC user) I realized the xslx document I linked is only read up until line 105 out of 180. Is there anything I can try to solve this out? Thanks for your help! Link to comment Share on other sites More sharing options...
Staff Patrick Connor Posted November 15, 2020 Staff Share Posted November 15, 2020 @leminilab Please can you create a new thread and supply your xlsx or ask for an upload link if it contains sensitive information Patrick Connor Serif Europe Ltd Latest V2 releases on each platform Help make our apps better by joining our beta program! "There is nothing noble in being superior to your fellow man. True nobility lies in being superior to your previous self." W. L. Sheldon Link to comment Share on other sites More sharing options...
leminilab Posted November 16, 2020 Author Share Posted November 16, 2020 Hi, I found the culprit: my first column was not always filled. Publisher stopped when it met an empty cell at row 105. It didn't stop at row 4 which was also emtpy though... Thanks for your help! Link to comment Share on other sites More sharing options...
Staff Patrick Connor Posted November 16, 2020 Staff Share Posted November 16, 2020 That's not ideal, perhaps it could handle this case better. Thanks for letting us know Patrick Connor Serif Europe Ltd Latest V2 releases on each platform Help make our apps better by joining our beta program! "There is nothing noble in being superior to your fellow man. True nobility lies in being superior to your previous self." W. L. Sheldon Link to comment Share on other sites More sharing options...
leminilab Posted November 16, 2020 Author Share Posted November 16, 2020 Hopefully you can replicate this without my file which is quite sensitive for me...🤔 If not, I can still find a way to erase the sensitive infos prior to sending it... Just let me know if you need the file! Thanks for your help and have a nice day! 😀 Link to comment Share on other sites More sharing options...
Staff Jon P Posted November 16, 2020 Staff Share Posted November 16, 2020 @leminilab I've just split this into it's own thread so we don't clutter the beta release thread. I'd be intrigued to see the file just to check if this is expected, could you upload it here please? Thanks leminilab 1 Serif Europe Ltd. - www.serif.com Link to comment Share on other sites More sharing options...
leminilab Posted November 16, 2020 Author Share Posted November 16, 2020 Done! I erased the sensitive infos but the problem remains: only the first 105 rows are taken into account. Hope that helps! Link to comment Share on other sites More sharing options...
leminilab Posted November 16, 2020 Author Share Posted November 16, 2020 I also observed that cell formatting from column C is not maintained. Link to comment Share on other sites More sharing options...
Staff Jon P Posted November 16, 2020 Staff Share Posted November 16, 2020 Quote I found the culprit: my first column was not always filled. This was actually the cause of the other issue too, a fair few rows in that file start with no data in the first column, apart from the first one all have been missed on import. I've passed this on to development. Quote I also observed that cell formatting from column C is not maintained. The spaces do seem to have been missed, I've also passed this on. Thanks for the reports! leminilab 1 Serif Europe Ltd. - www.serif.com Link to comment Share on other sites More sharing options...
Recommended Posts