× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2009-01-23T00:31:23Z  · last modified 2009-01-27T18:54:34Z

Saving a column with image to excel -- com.aspose.cells.CellsException


Dev mattbrumley(*)
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - Charts
Version 07.5

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)

2 attachments

Issue #2287

Closed
Fixed
Resolved 2009-01-27T18:54:34Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017