You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Oct 12, 2023. It is now read-only.
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.
The text was updated successfully, but these errors were encountered:
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 :)
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 ?
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>
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.
The text was updated successfully, but these errors were encountered: