Spreadsheet must be updated
From: https://www.simantics.org/redmine/issues/7822
Spreadsheet functionality is currently unstable and/or broken. The following small issues have been found:
- "1" + "1" = #VALUE!, but should interpret the numbers as Integers.
- Empty cells have "null" SpreadsheetStyle, which causes an exception to be thrown every time a new cell is given an initial value:
java.lang.IllegalArgumentException: org.simantics.spreadsheet.graph.SpreadsheetStyle@94f3600e is not of expected class at org.simantics.databoard.binding.Binding.compare(Binding.java:439) at org.simantics.databoard.util.DataValueUtil.equals(DataValueUtil.java:113) at org.simantics.databoard.Bindings.equals(Bindings.java:815) at org.simantics.databoard.binding.mutable.Variant.equals(Variant.java:128) at org.simantics.db.impl.query.QueryProcessor.compareTo(QueryProcessor.java:2528) at org.simantics.db.impl.query.QueryProcessor.update(QueryProcessor.java:2670) at org.simantics.db.impl.query.QueryProcessor$7.execute(QueryProcessor.java:2781) at gnu.trove.impl.hash.TObjectHash.forEach(TObjectHash.java:137) at org.simantics.db.impl.query.QueryProcessor.performDirtyUpdates(QueryProcessor.java:2774) at fi.vtt.simantics.procore.internal.SessionImplSocket.handleUpdatesAndMetadata(SessionImplSocket.java:3535) ... 2 common frames omitted Wrapped by: org.simantics.db.exception.DatabaseException: Unexpected exception in ReadGraph.syncRequest(Read) at org.simantics.db.impl.graph.ReadGraphImpl.syncRequest(ReadGraphImpl.java:2603) at org.simantics.db.impl.graph.ReadGraphImpl.syncRequest(ReadGraphImpl.java:2517) at org.simantics.db.layer0.variable.Variables.requestNodeValue(Variables.java:618) at org.simantics.db.layer0.variable.Variables.requestNodeValue(Variables.java:614) at org.simantics.db.layer0.function.All.standardGetValue1(All.java:104) at org.simantics.db.layer0.function.All$1.getValue(All.java:418) at org.simantics.db.layer0.variable.StandardGraphPropertyVariable.getValue(StandardGraphPropertyVariable.java:129) at org.simantics.spreadsheet.graph.CellValue.perform(CellValue.java:25) at org.simantics.db.impl.query.ReadEntry$1.recompute(ReadEntry.java:87) at org.simantics.db.impl.query.QueryProcessor.compareTo(QueryProcessor.java:2507) at org.simantics.db.impl.query.QueryProcessor.performScheduledUpdates(QueryProcessor.java:2588) at fi.vtt.simantics.procore.internal.SessionImplSocket.handleUpdatesAndMetadata(SessionImplSocket.java:3536) at fi.vtt.simantics.procore.internal.SessionRequestManager$4.run(SessionRequestManager.java:238) at org.simantics.db.impl.query.QueryThread.run(QueryThread.java:251)