Strings of the form ###.a are reinterpreted as times
Both in direct data entry and inside formulas, strings of the form number-dot-letter are getting reinterpreted as times, and also ignoring the letter so different strings of this form with the same number but different letter are considered equal.
Repro:
- Type "3.A" into a cell, hit enter
- Cell displays as "0:00:03"
- Click on the cell
- Formula bar says "0:00:02.9"
- Format the cell
- Choose Number, 20 decimal places, click OK
- Cell now says "0.00003356481481481482" (Expected: display as 3.A throughout)
The exact same things would display if you typed "3.B" or "3.Z" or "3.a"—including the numeric representation to 20 decimal places—but "3.AA" is kept as a string, as-is. This bug also manifests within formulas (seems to be same bug):
Repro:
- New sheet
- Type '3.A into A1 (including single quote to force string interpretation)
- Similarly '3.B and '3.C into A2 and A3
- In A4, type formula: =countif(A1:A3,"3.A")
- Cell displays 3 (Expected: 1)
In both cases, Excel 2013 displays the expected behaviour.
Running gnumeric 1.12.35 on Linux Mint 19. (Old, I know, sorry)