HTML text in a column crashes the Excel export.

0
Beware when you are trying to do an Export to Excel in Mx 4.8.9 when there is HTML text in a column (with the Mendix standard button). Mendix will throw an error. Have not checked it yet if this also applies for Mx5. I filled a bug report (ticketnr 206065). Regards, Ronald An error has occurred while handling the request. [User 'MxAdmin' with session id '7aa656f1-d251-461a-bcd3-79b5cd484d83' and roles 'Administrator'] -------- java.util.concurrent.ExecutionException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{}', all database changes executed by this action were rolled back at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) at java.util.concurrent.FutureTask.get(FutureTask.java:83) at com.mendix.core.action.client.PollBackgroundJobAction.handleJobCompletion(PollBackgroundJobAction.java:95) at com.mendix.core.action.client.PollBackgroundJobAction.execute(PollBackgroundJobAction.java:69) at com.mendix.externalinterface.connector.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:364) at com.mendix.externalinterface.connector.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:356) at com.mendix.externalinterface.connector.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:356) at com.mendix.externalinterface.connector.RequestDispatching$Worker$$anonfun$receive$2.apply(RequestDispatching.scala:185) at com.mendix.externalinterface.connector.RequestDispatching$Worker$$anonfun$receive$2.apply(RequestDispatching.scala:179) at akka.actor.Actor$class.apply(Actor.scala:545) at com.mendix.externalinterface.connector.RequestDispatching$Worker.apply(RequestDispatching.scala:175) at akka.actor.LocalActorRef.invoke(ActorRef.scala:910) at akka.dispatch.MessageInvocation.invoke(MessageHandling.scala:25) at akka.dispatch.ExecutableMailbox$class.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:223) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:123) at akka.dispatch.ExecutableMailbox$class.run(ExecutorBasedEventDrivenDispatcher.scala:195) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.run(ExecutorBasedEventDrivenDispatcher.scala:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at akka.dispatch.MonitorableThread.run(ThreadPoolBuilder.scala:192) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.processErrorState(CoreAction.java:536) Caused by: java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters at org.apache.poi.hssf.usermodel.HSSFCell.setCellValue(HSSFCell.java:555) at com.mendix.modules.exportmanager.excel.ExcelExporter.generateCell(ExcelExporter.java:251) at com.mendix.modules.exportmanager.excel.ExcelExporter.generateColumn(ExcelExporter.java:176) at com.mendix.modules.exportmanager.excel.ExcelExporter.generateWorkbook(ExcelExporter.java:78) at com.mendix.modules.exportmanager.excel.ExcelExporter.generateXLS(ExcelExporter.java:55) at com.mendix.modules.exportmanager.ExportManagerModule.generateXLS(ExportManagerModule.java:71) at com.mendix.core.action.client.ExportAction.exportToExcel(ExportAction.java:264) at com.mendix.core.action.client.ExportAction.exportGrid(ExportAction.java:123) at com.mendix.core.action.client.ExportAction.access$000(ExportAction.java:81) at com.mendix.core.action.client.ExportAction$ExportCoreAction.execute(ExportAction.java:447) at com.mendix.core.action.client.ExportAction$ExportCoreAction.execute(ExportAction.java:425) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:478) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:463) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(CustomMonitoredAction.scala:22) at com.mendix.externalinterface.connector.RequestDispatching$Worker$$anonfun$receive$2.apply(RequestDispatching.scala:185) at com.mendix.externalinterface.connector.RequestDispatching$Worker$$anonfun$receive$2.apply(RequestDispatching.scala:179) at akka.actor.Actor$class.apply(Actor.scala:545) at com.mendix.externalinterface.connector.RequestDispatching$Worker.apply(RequestDispatching.scala:175) at akka.actor.LocalActorRef.invoke(ActorRef.scala:910) at akka.dispatch.MessageInvocation.invoke(MessageHandling.scala:25) at akka.dispatch.ExecutableMailbox$class.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:223) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:123) at akka.dispatch.ExecutableMailbox$class.run(ExecutorBasedEventDrivenDispatcher.scala:195) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.run(ExecutorBasedEventDrivenDispatcher.scala:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) at akka.dispatch.MonitorableThread.run(ThreadPoolBuilder.scala:192)
asked
1 answers
2

From your stacktrace: "Caused by: java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters" I don't think this is an HTML issue.

answered