Mangled numbers in Documents

asked 2015-09-23 14:40:04 +0300

pichlo gravatar image

I received a contacts list in an Excel format and some of the phone mubers there appear mangled:

image description

They all appear correct when the same file is opened in Excel on a PC.

The problem is presumably that the Documents app treats them as floating point numbers for some reason. They are all UK mobile phone numbers and as such start with 07... It looks like Documents interprets that as a floating point mumber 0.7... and then suffers some floating-point inaccuracy problems.

When the document was edited to insert a space between groups of digits (07123456789 -> 07123 456789), the problem disappeared. Excel showed the numbers correctly with or without the space.

edit retag flag offensive close delete

Comments

2

Floating point phone numbers are hilarious. Better use double precision.

ScumCoder ( 2015-09-23 15:51:21 +0300 )edit
1

Hi @pichlo, are you on 1.1.9.28?

jiit ( 2015-09-23 15:56:12 +0300 )edit

Ahh, yes, I knew I'd forget something!

Yes, 1.1.9.28.

pichlo ( 2015-09-23 16:39:01 +0300 )edit