# Problem with Save Button on Easy Chart **URL:** \ **Category:** Ignition\ **Created:** [July 25, 2011, 10:33am UTC](https://forum.inductiveautomation.com/t/problem-with-save-button-on-easy-chart/3128 "2011-07-25T10:33:48Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![peadair](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@peadair](https://forum.inductiveautomation.com/u/peadair)\ **Post date:** [July 25, 2011, 10:33am UTC](https://forum.inductiveautomation.com/t/problem-with-save-button-on-easy-chart/3128/1 "2011-07-25T10:33:48Z")
I have come across a problem with my easy chart so far as when i select to view data for the last week and then export it to an excel sheet it is working fine but when i choose to view data for the last month i can view it on the easy chart but when i choose to export it the only bit of information i am getting in excel is this Text - ‘’ I have also an expression bound to the Tag History Resolution which is - if(dateDiff({Root Container.ctg\_Chart.startDate},{Root Container.ctg\_Chart.endDate},“minute”)\>10080, dateDiff({Root Container.ctg\_Chart.startDate},{Root Container.ctg\_Chart.endDate},“minute”)/0.2, if(dateDiff({Root Container.ctg\_Chart.startDate},{Root Container.ctg\_Chart.endDate},“minute”)\>1440, dateDiff({Root Container.ctg\_Chart.startDate},{Root Container.ctg\_Chart.endDate},“minute”)/0.2, dateDiff({Root Container.ctg\_Chart.startDate},{Root Container.ctg\_Chart.endDate},“minute”)/0.2)) Is this what could be causing the problem. ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [July 26, 2011, 3:53pm UTC](https://forum.inductiveautomation.com/t/problem-with-save-button-on-easy-chart/3128/2 "2011-07-26T15:53:11Z")
I’m not sure if that expression is causing the problem, but it probably can’t be helping. The expression, as posted, is a lot of work for nothing as all the conditions do the same thing. But, I suspect that’s because the numbers are probably different that they were when it first written. Using the first case as an example, a range of 10080 minutes (1 week) would result in a resolution of over 50000 points. Considering that the default for the chart is 300, that’s a big step up. If the chart is displaying the data, that’s a good sign… but maybe the CSV export isn’t handling so many points well? Have you looked at the Java console for the client? Try going to Help\>Diagnostics. There might be something there, maybe an out of memory. The text that you are getting is the UTF-8 marker rendered to ascii, so the file is being opened, and then nothing else is getting written. You might try removing that expression and just setting the resolution to something a bit more modest, like 1000, and see if that helps. Regards, ---
**Author:** ![peadair](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@peadair](https://forum.inductiveautomation.com/u/peadair)\ **Post date:** [July 27, 2011, 3:59pm UTC](https://forum.inductiveautomation.com/t/problem-with-save-button-on-easy-chart/3128/3 "2011-07-27T15:59:26Z")
Thanks for that colby, You were correct, the error i was getting was as below so i just recalculated the expression and it is working great now and am getting far fewer points. ’ Exception in thread “AWT-EventQueue-0” java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Unknown Source) at java.lang.AbstractStringBuilder.expandCapacity(Unknown Source) at java.lang.AbstractStringBuilder.append(Unknown Source) at java.lang.StringBuffer.append(Unknown Source) at java.io.StringWriter.write(Unknown Source) at java.io.PrintWriter.write(Unknown Source) at java.io.PrintWriter.write(Unknown Source) at com.inductiveautomation.ignition.common.script.builtin.DatasetUtilities.dataSetToExcel(DatasetUtilities.java:551) at com.inductiveautomation.factorypmi.application.script.builtin.ClientDatasetUtilities$3.writeToFile(ClientDatasetUtilities.java:81) at com.inductiveautomation.ignition.client.script.ClientFileUtilities$CharFileWritingTask.writeToFile(ClientFileUtilities.java:91) at com.inductiveautomation.factorypmi.application.script.builtin.FPMIFileUtilities.saveToFile(FPMIFileUtilities.java:113) at com.inductiveautomation.factorypmi.application.script.builtin.ClientDatasetUtilities.exportExcel(ClientDatasetUtilities.java:77) at com.inductiveautomation.factorypmi.application.components.PMIEasyChart$EasyChart.exportExcel(PMIEasyChart.java:2109) at com.inductiveautomation.factorypmi.application.components.PMIEasyChart.exportExcel(PMIEasyChart.java:508) at com.inductiveautomation.factorypmi.application.components.PMIEasyChart.exportExcel(PMIEasyChart.java:512) at com.inductiveautomation.factorypmi.application.components.PMIEasyChart.actionPerformed(PMIEasyChart.java:503) at com.inductiveautomation.factorypmi.application.components.util.ClickableIconButton.fireActionEvent(ClickableIconButton.java:142) at com.inductiveautomation.factorypmi.application.components.util.ClickableIconButton.setPress(ClickableIconButton.java:188) at com.inductiveautomation.factorypmi.application.components.util.ClickableIconButton.mouseReleased(ClickableIconButton.java:107) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source)’ Thank you