Skip to content
This repository has been archived by the owner on Oct 12, 2023. It is now read-only.

Phone number exported as number #4

Open
SelfMan opened this issue May 13, 2014 · 3 comments
Open

Phone number exported as number #4

SelfMan opened this issue May 13, 2014 · 3 comments
Labels

Comments

@SelfMan
Copy link
Contributor

SelfMan commented May 13, 2014

Leading zeroes are stripped on export and the value is stored in a cell defined as a number, not as a text. So for exapmple 0912345678 is stripped to 912345678.
If the number contains a space character, its treated properly as text. That is also valid for the full international format case. i.e. +421912345678.What I havent tested is 00421912345678, but I assume it will cause the same problem.

@softmonkeyjapan
Copy link
Owner

Hi,
Thanks for your feedback. Will work on that probably tonight or tomorrow and push a fix on master.
Also, you are more than welcome to contribute to the project by helping fixing it as well.
Stay tuned :)

@softmonkeyjapan
Copy link
Owner

Well, I just checked, and I cannot reproduce this issue. Which version of Excel are you using and on which OS are you using it?
Is this issue happen on both Invoice and Export ?

@SelfMan
Copy link
Contributor Author

SelfMan commented May 14, 2014

Its Office 2010 on Windows 7. The problem appears in all exports. I am testing the export on a OpenCart 1.5.5.1 Community Edition.
EDIT: After I've checked the XML, it contains only the number without the leading zero.
<c r="A20" s="10"><v>910691880</v></c>

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

2 participants