Export lead as Xlsx phone not correct

[Riad]

Hi everybody
When add lead phone number as international formula (start with +) like +966000000 and export it as xlsx it add ( ' ) so the number will be ( '+966000000 ). This happen with new versions only. Is there any idea about that?
Thank you all.

[esforim]

I'm guessing it to prevent it being convert to a value/date/etc.

Some of our numbers start with a "0", and whenever you start with a 0 for Excel the 0 disappear. For example

00012 (INVOICE) become 12 in the Excel.

[Riad]

Hi, espocrm thank you for reply , but this not happen with the older version. It was exported right.

[item]

Hi,
maybe, i think is this :

https://github.com/espocrm/espocrm/b.../Xlsx.php#L916

you can try modify and test ?

[Riad]

Yes item thank you. It works well

[esforim]

I guess you would now have to modify this file with each upgrade or anytime it affect the file. Alternative you can feature request it but look like this code is intentionally add so I doubt it will be remove.

Anyway congratulation on getting it to work.

PS: espocrm is official account (abandoned), I'm just another user like you.

[Riad]

Thank you so much