beginnerr Posted June 15, 2021 Posted June 15, 2021 I usually use SigmaPlot to create graph. The graphs of SigmaPlot can be copy-paste to PowerPoint. But, they could not paste to all Affinity products properly. The pasted graphs and their labels showed upside-down and flipped. I would like to use affinity softwares to create published reports, so that I am happy to know the solutions. Quote
firstdefence Posted June 15, 2021 Posted June 15, 2021 Welcome to the forum @beginnerr Could you not export to a graphic format like PNG or export to a PDF? Sigmaplot import export options. Quote iMac 27" 2019 Sequoia 15.0 (24A335), iMac 27" Affinity Designer, Photo & Publisher V1 & V2, Adobe, Inkscape, Vectorstyler, Blender, C4D, Sketchup + more... XP-Pen Artist-22E, - iPad Pro 12.9 (Please refrain from licking the screen while using this forum) Affinity Help - Affinity Desktop Tutorials - Feedback - FAQ - most asked questions
beginnerr Posted June 17, 2021 Author Posted June 17, 2021 Very thank you for the information. Anyway, I would like to use enhanced MetaFile for export. Attached files reveal the comparison when I paste the exported emf file to powerpoint and designer. I think affinity program could not process the emf file properly. Quote
DrDDS Posted December 30, 2021 Posted December 30, 2021 Same issue here. Copy and paste from SigmaPlot to AD ends up with flipped graphs. Is there any way to fix this issue? Quote
NotMyFault Posted December 30, 2021 Posted December 30, 2021 14 minutes ago, DrDDS said: Same issue here. Copy and paste from SigmaPlot to AD ends up with flipped graphs. Is there any way to fix this issue? Any chance that you can upload an example file so we can test/reproduce on our side? Quote Mac mini M1 A2348 | MBP M3 Windows 11 - AMD Ryzen 9 5900x - 32 GB RAM - Nvidia GTX 1080 LG34WK950U-W, calibrated to DCI-P3 with LG Calibration Studio / Spider 5 | Dell 27“ 4K iPad Air Gen 5 (2022) A2589 Special interest into procedural texture filter, edit alpha channel, RGB/16 and RGB/32 color formats, stacking, finding root causes for misbehaving files, finding creative solutions for unsolvable tasks, finding bugs in Apps. I use iPad screenshots and videos even in the Desktop section of the forum when I expect no relevant difference.
DrDDS Posted December 30, 2021 Posted December 30, 2021 Please find attached a Sigmaplot test file containing a simple graphSigmaPlot_test_file.JNB. In the picture, you can appreciate the original graph in Sigmaplot (right side) and the flipped image in AD (simply using Ctrl+C and Ctrl+V). Different but still weird results can be obtained when graph is exported as Metafile in sigmaplot and then place into AD. In addition, some issues are present also when copy and paste from GraphPad Prism. Using the provided test fileGraphPad_test_file.pzfx, some graphs (e.g. table 1) are copied with missing text and lines (see 2nd screenshot, upper graph) and some are correct (e.g. table 3 of the included test file, bottom graph in the screenshot) I hope this will help Quote
Old Bruce Posted December 30, 2021 Posted December 30, 2021 Does Sigma Plot offer a PDF export option? Try using that. Quote Mac Pro (Late 2013) Mac OS 12.7.6 Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 | Beta versions as they appear. I have never mastered color management, period, so I cannot help with that.
DrDDS Posted December 30, 2021 Posted December 30, 2021 6 minutes ago, Old Bruce said: Does Sigma Plot offer a PDF export option? Try using that. Yes in principle, but this procedure is more time consuming and most importantly the graph imported though PDF cannot be edited. Quote
NotMyFault Posted December 30, 2021 Posted December 30, 2021 SVG might be worth a a try. Unfortunately Affinity seemingly doesn’t handle pasted EMF data correctly. As this is a Windows only format, not officially support (for import / export), i personally would look for other options to transfer data between apps. Quote Mac mini M1 A2348 | MBP M3 Windows 11 - AMD Ryzen 9 5900x - 32 GB RAM - Nvidia GTX 1080 LG34WK950U-W, calibrated to DCI-P3 with LG Calibration Studio / Spider 5 | Dell 27“ 4K iPad Air Gen 5 (2022) A2589 Special interest into procedural texture filter, edit alpha channel, RGB/16 and RGB/32 color formats, stacking, finding root causes for misbehaving files, finding creative solutions for unsolvable tasks, finding bugs in Apps. I use iPad screenshots and videos even in the Desktop section of the forum when I expect no relevant difference.
Old Bruce Posted December 30, 2021 Posted December 30, 2021 54 minutes ago, DrDDS said: Yes in principle, but this procedure is more time consuming and most importantly the graph imported though PDF cannot be edited. You should be able to edit a PDF. I am guessing that the problem here is that SigmaPlot uses Cartesian coordinates, 0,0 at the bottom left. Whereas Affinity places 0, 0 at the top left. Quote Mac Pro (Late 2013) Mac OS 12.7.6 Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 | Beta versions as they appear. I have never mastered color management, period, so I cannot help with that.
NotMyFault Posted December 30, 2021 Posted December 30, 2021 1 hour ago, Old Bruce said: You should be able to edit a PDF. I am guessing that the problem here is that SigmaPlot uses Cartesian coordinates, 0,0 at the bottom left. Whereas Affinity places 0, 0 at the top left. So true. And Affinity‘s reluctance to offer the option to revers y axis to start bottom left is really annoying. Quote Mac mini M1 A2348 | MBP M3 Windows 11 - AMD Ryzen 9 5900x - 32 GB RAM - Nvidia GTX 1080 LG34WK950U-W, calibrated to DCI-P3 with LG Calibration Studio / Spider 5 | Dell 27“ 4K iPad Air Gen 5 (2022) A2589 Special interest into procedural texture filter, edit alpha channel, RGB/16 and RGB/32 color formats, stacking, finding root causes for misbehaving files, finding creative solutions for unsolvable tasks, finding bugs in Apps. I use iPad screenshots and videos even in the Desktop section of the forum when I expect no relevant difference.
John Rostron Posted December 31, 2021 Posted December 31, 2021 If you can export your graph in an editable format, then you should be able to do a global search and replace for any y-coordinates, replacing them by height-y. You would look for expressions like (x,y) an replace by (x,height-y), using a regular expression. John Quote Windows 11, Affinity Photo 2.4.2 Designer 2.4.2 and Publisher 2.4.2 (mainly Photo). CPU: Intel Core i5 8500 @ 3.00GHz. RAM: 32.0GB DDR4 @ 1063MHz, Graphics: 2047MB NVIDIA GeForce GTX 1050
DrDDS Posted January 3, 2022 Posted January 3, 2022 Thanks for all suggestions. Unfortunately, this workaround is impractical (too time consuming for me, more generally too hard for the average user). Is there any chance to see this bug fixed in the near future? AD would have a huge potential in my working enviroment, but this problem prevents me from switching John Rostron 1 Quote
walt.farrell Posted January 3, 2022 Posted January 3, 2022 2 hours ago, DrDDS said: Is there any chance to see this bug fixed in the near future? It's not acknowledged as a bug yet. This discussion is taking place in the Questions part of the forum, not the Bugs part of the forum. It has had no participation from Serif, and in particular there's no bug tag showing that it's been logged. This is the only topic mentioning Sigmaplot, so it isn't reported elsewhere, either. From that, I would conclude there's little chance of a change in the near future. Leigh 1 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.5, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.5
Staff Leigh Posted January 4, 2022 Staff Posted January 4, 2022 We've had similar issues in the past with Prism when copying and pasting - these are logged with the developers. I will log this issue with SigmaPlot separately with our developers. Thanks for bringing this to our attention 👍 Quote
Dylan Indicott Posted December 16, 2024 Posted December 16, 2024 (edited) Good afternoon. Since SigmaPlot (SP) v14.5, there has been a problem with copying-pasting figures, in particular column charts, from SP to MS Word; then, saving that Word file as a .PDF. Scenario: 1) add data to SP; 2) create column chart; 3) copy-paste column chart to MS Word as either SP object or enhanced metafile; 4) save Word file; 5) save word file as .PDF; 6) if using SP v14.5, 15, or now 16, columns disappear leaving error bars and other non-column chart features (see attached). SigmaPlot Tech folks do not seem to know how to fix this, or they are not interested in fixing. Either way, SP v14.0 is the only version I currently know of that does not 'disappear' columns following saving a Word file with copied-pasted SP column chart(s) as a .PDF. Although options exist for exporting SP figures as .PDFs, picture files, and other file types, in contrast to simple copy-paste capabilities these formats are more cumbersome to manage and suffer from other inconveniences. Anyone else have this problem? Anyone have a work-around, other than exporting SP figure as .PDF or other file type, or fix? Thank you for your time and consideration; have a good day. 2024-12-16_Col Chart SPv14 vs SPv16.pdf Edited December 16, 2024 by Dylan Indicott Quote
walt.farrell Posted December 16, 2024 Posted December 16, 2024 2 hours ago, Dylan Indicott said: Since SigmaPlot (SP) v14.5, there has been a problem with copying-pasting figures, in particular column charts, from SP to MS Word Welcome to the Affinity forums, @Dylan Indicott. Are the Affinity applications involved in your scenario at all? If not, this doesn't really seem relevant here, and should probably be addressed to the SigmaPlot developers or to Microsoft. 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.5, Apple Pencil 2, Magic Keyboard Mac: 2023 M2 MacBook Air 15", 16GB memory, macOS Sequoia 15.5
Dylan Indicott Posted December 17, 2024 Posted December 17, 2024 Hi Mr. Farrell: Apologies. Came across this forum while searching for input-on / solutions-for a complication I have had using newer versions of SigmaPlot (SP). Will continue efforts with SP tech folks re: mitigating this problem. Thank you for your consideration. D walt.farrell 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.