wijmo-812-sorting-bug

by lucksm1

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<link rel="stylesheet" href="https://cdn.grapecity.com/wijmo/5.latest/styles/wijmo.min.css">
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.input.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.filter.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.detail.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.sheet.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.grouppanel.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.xlsx.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.xlsx.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.multirow.min.js"></script>
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">

	<script type="text/javascript" src="../js/jquery.js"></script>
	<script type="text/javascript" src="../js/jquery-ui/jquery-ui.js"></script>
	<script type="text/javascript" src="../js/babel-polyfills.js"></script>
	<script type="text/javascript" src="../js/wijmo/wijmo.min.js"></script>
	<script type="text/javascript" src="../js/wijmo/wijmo.input.min.js"></script>
	<script type="text/javascript" src="../js/wijmo/wijmo.grid.min.js"></script>
	<script type="text/javascript" src="../js/wijmo/wijmo.grid.filter.min.js"></script>
	<script type="text/javascript"...

JavaScript

let flexSheet = new wijmo.grid.sheet.FlexSheet('#flexsheet');
flexSheet.allowSorting = true;
flexSheet.showSort = true;
var sheet = new wijmo.grid.sheet.Sheet(flexSheet, null, 'Sheet 1', 3, 2);

var data = [
  { 'Col A': '23', 'Col B': '=(0.6*A2)', 'Col C': '13.80', 'Col D': '=(C2 <= B2)', 'Col E': '=(Value(C2) <= Value(B2))' },
];

sheet.itemsSource = data;
flexSheet.sheets.push(sheet);
flexSheet.refresh();