When using Solid Edge Inspector and adding a new balloon number, it will be added on the last line of the QDAS Spreadsheet table, therefore displaying the order of creation but not the incremental Item number.
In this example, the following balloons (0,1,2,3,4,5,6,15,16,17) currently exist.
The user then adds a new balloon linked to a dimension and sets the item number to 7:
The resulting QDAS Spreadsheet sort does not show the incremental Item numbering, but rather the balloon creation order.
This behavior depends on how the table column gets sorted.
In this case, “Numerical” should be activated via the right click context menu:
Then the result will be correct: