Description: If I highlight all 5 complete columns, col B will not put item 0 (zero) at the end of that column instead of at the top. I have tried reformatting the column. Calc never has crashed nor have I lost any data. Steps to Reproduce: 1. I can provide a screen shot. 2. Create a spreadsheet with columns listed above. 3. Put one single zero as if listing race car numbers, such as 0, 1, 02, 2, 3, 4, 04, 5, 7, 9, & 10. Actual Results: zero goes to the bottom. Expected Results: Put the zero should be at the top. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Team # Driver Reg Playoff SHR 00 Cole Custer 752 1 JMS 1 Elliott Sadler 754 4 JDM 01 Vinnie Miller R 186 RCR 2 Matt Tift 548 RCR 3 Ty Dillon I 0 GKR 4 Ross Chastain 454 JRM 5 Michael Annette 405 JRM 7 Justin Algaier 751 14 RWR 8 Ray Black II 67 HMS 9 Tyler Reddick R 606 6 MKR 11 Ryan Truex 596 RFR 12 Austin Cindric R 559 1 CLR 13 Timmy Hill 85 MHM 15 B. J. McLeod 170 RFR 16 Ryan Reed 514 JGR 18 Kyle Busch I 0 JGR 19 Brandon Jones 623 1 JGR 20 Christopher Bell R 771 24 RCR 21 Daniel Hemric 754 2 JMR 23 Chase Elliott 0 BDR 35 Joey Gase 296 MGR 36 Alex Labbe R 327 SRM 38 Jeff Green 84 RSS 39 Ryan Seig 354 CLM 40 Chad Finchum R 127 CGR 42 Kyle Larson I 0 JHR 45 Josh Bilicki R 127 TCR 51 Jeremy Clements 350 JMR 52 David Starr 218 BJM 55 Bayley Currey I 0 RFR 60 Chase Briscoe 203 CLM 66 Carl Long 2 JPM 74 Stephen Leicht 63 BDR 76 Spencer Boyd R 224 RWR 78 JA Junior Avila 0 SRV 89 Morgan Shepherd 13 DGM 90 Josh Williams 156 SBR 93 J.J. Yeley 177 GCR 0 Garrett Smithley 298 Sort list is column with # symbol.
Created attachment 144241 [details] 5 columns mentioned in bug
The only reason to zero going to the bottom is if it's introduced as text or in a cell formatted as text. Please attach a file with only one sheet with your sample.
I have found the error.
Please would be nice to know what was the issue, perhaps can help someone else. And then must be resolved as not a bug, nothing was fixed on the program.