Excel export error "String value too long"

TakiaSadler
New Contributor

We're trying to export a Form into Excel and we are receiving the following error.  Has anyone had this error when trying to export a form into Excel?

TakiaSadler_1-1681306588753.png

 

Thanks

1 ACCEPTED SOLUTION

ChrisLoran
Valued Contributor

There is very little information here that we can go on.
For example , there may be more information in the error log (on the system tab).

Also when you say "export a form", I presume you mean export a cube view : So have you tried opening the Cube View from the Excel add-in to see if that works?

Does it work if you try to open the Cube View from the Embedded Spreadsheet component?

Does it work exporting other Cube Views to Excel?  If so, then what are some key differences with this particular Cube View?

That would then throw some light on whether it's an Excel limitation or something else.


That error message looks more like a DevExpress error, rather than a OneStream error.
Is the cube view trying to show large amounts of text?  I believe Excel has a limitation of 32k characters in a cell.
So if you have a cube view with a ton of cell text detail , e.g. on V#Annotation, then that might blow the Excel limit.


But there is no context here , so it is difficult to answer.

Since this is more an error and you need a support level response then these sorts of questions would better be handled by opening a ticket with OneStream Support, stating the OneStream version, some context, some information of the Cube View, whether it works from the Embedded Spreadsheet, some information from the system error log etc...

View solution in original post

2 REPLIES 2

ChrisLoran
Valued Contributor

There is very little information here that we can go on.
For example , there may be more information in the error log (on the system tab).

Also when you say "export a form", I presume you mean export a cube view : So have you tried opening the Cube View from the Excel add-in to see if that works?

Does it work if you try to open the Cube View from the Embedded Spreadsheet component?

Does it work exporting other Cube Views to Excel?  If so, then what are some key differences with this particular Cube View?

That would then throw some light on whether it's an Excel limitation or something else.


That error message looks more like a DevExpress error, rather than a OneStream error.
Is the cube view trying to show large amounts of text?  I believe Excel has a limitation of 32k characters in a cell.
So if you have a cube view with a ton of cell text detail , e.g. on V#Annotation, then that might blow the Excel limit.


But there is no context here , so it is difficult to answer.

Since this is more an error and you need a support level response then these sorts of questions would better be handled by opening a ticket with OneStream Support, stating the OneStream version, some context, some information of the Cube View, whether it works from the Embedded Spreadsheet, some information from the system error log etc...

Thank you for your response.  It appears that issue is the amount of data, which is most likely an Excel limitation and not OneStream as you mentioned.