leading zeros lost when using insertNewRowBefore

Topics: User Forum
Jul 24, 2014 at 3:12 PM
Edited Jul 24, 2014 at 3:59 PM
Hello everyone,

I'm developping he website of our sportsclub, and i want to let the members register to the club via the website. I'm trying to use phpexcel to store the members information in an xlsx file, so that the trainers can have acces to these information.

Now my problem comes with the phone numbers:
I'm using the string data type to keep the eading zeros. I'm not using some number format, because the phone numbers can have different length (fix/mobile, or different countries becaus e we live next to the country border).
To insert the information of a new member in the file, I insert a row at the correct place. At that moment, all leading zeros of the rows below get lost. When printing the values of the cells right before, the zeros are still there, but right after the insertion of the row, the zeros disapear, altought the string data type seems to be kept.

I found a fix for the rows above by putting an ' in front of each number, but that didn't help for the lower rows. (without that ' i.e. only string data type, the leading zeros of the upper rows are also lost.)

Can anyone help me how to keep all the leading zeros?

(my server is running php 5.3 and 'm using phpexcel 1.8.0)