Execute the below query and save the grid results to excel without the Chart. It gives an error message and an error message is displayed "You want to put a string longer than 32K to Cell P5" followed by an exception
FILE--Options --Results Convert Binary to Hex --- Ticked.
select * from employees
go
.setResultSettings 'Index=1,
CategoryFields="[EmployeeID]",
SeriesFields="[ReportsTo]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=534,
Chart="{column}",
RotX=-44,
RotY=-590,
RotZ=0,
Zoom=20.606081,
ScaleData=true,
ShowLegend=true,
ShowGrid=true,
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
Width=16.0,
Height=10.0,
Depth=5.0,
SeriesSpacing=1.0,
CategorySpacing=1.0,
Font="PMingLiU-10",
TopColor="#E9D9A9",
BottomColor="#FFFFFF",
PanX=-8.0,
PanY=-5.0,
Lighting=Default,
View2D=false,
StackedPercent=false,
ShowValueAxis=true,
ShowCategoryAxis=true,
ShowSeriesAxis=true,
ValueAxisNumberFormat=###0,
UseCategoryAxisRange=false,
MergeAxis=false,
SeriesAlias="default",
SeriesSubType="",
SeriesColumnType="Cube",
SeriesMin="default",
SeriesMax="default",
SeriesColor="default",
SeriesFunctionMetaData="true",
LegendPosition=Top Right,
LegendWidthType=Fit,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=false,
FixedCategoryCount=0'
com.aspose.cells.CellsException: You want to put a string longer than 32K to Cell P5.
at com.aspose.cells.Cell.setValue(Unknown Source)
at nmfl.LXkz.a(Unknown Source)
at nmfl.LXkz.d(Unknown Source)
at nmfl.bOda.a(Unknown Source)
at nmfl.bOda.a(Unknown Source)
at nmfl.bOda.a(Unknown Source)
at nmfl.bOda.a(Unknown Source)
at nmfl.iJfv.do(Unknown Source)
at nmfl.iJfv.onOk(Unknown Source)
at nmfl.iJfv.c(Unknown Source)
at nmfl.VwxI.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6041)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5806)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4413)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2440)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
at java.awt.Dialog$1.run(Dialog.java:1045)
at java.awt.Dialog$3.run(Dialog.java:1097)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:1095)
at java.awt.Component.show(Component.java:1422)
at java.awt.Component.setVisible(Component.java:1375)
at java.awt.Window.setVisible(Window.java:806)
at java.awt.Dialog.setVisible(Dialog.java:985)
at nmfl.iJfv.QE(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.AgJv.zv(Unknown Source)
at nmfl.iNZG.a(Unknown Source)
at nmfl.tJPN.a(Unknown Source)
at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.HSwX.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Component.java:6041)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5806)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4413)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Component.dispatchEvent(Component.java:4243)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
We are now trimming strings that are exported to excel (to 1024 characters)
Issue #2287 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
We are now trimming strings that are exported to excel (to 1024 characters)