Phone number format style not being applied properly.

[schir1964]

PHPExcel verrsions: 1.7.6 and 1.7.7

Issue:
The phone number format (000") "000-0000 is not be applied properly.
A cell with value 5555555555 should return (555) 555-5555
but instead the following value is returned: (5555555555) 5555555555-5555555555

Code:
The style code is processed in the PHPExcel/Style/NumberFormat.php file in the toFormattedString() method.

[MarkBaker]

Not forgotten, but I'm trying to work out a good generic way of implementing. I know you already have a temporary solution

[schir1964]

I figured as much, but I wanted to make sure the issue was migrated over
to the git-hub repository.

• Christopher Mullins

On 7/23/2012 5:40 PM, Mark Baker wrote:

Not forgotten, but I'm trying to work out a good generic way of implementing.

---

Reply to this email directly or view it on GitHub:
#14 (comment)

[MarkBaker]

I've worked out the basic mechanic for handling the masking in a way that will work as readily with mask="0000-00-00" and number 19601219 as with your phone number example.... the difficulty now is identifying masks of that type without affecting other standard masks such as #,##0.00

[schir1964]

I know what you mean. When I initially researched it myself I also realized that the main hurdle is how to identify the mask as a phone number mask vs another type of number mask and keep the code generic. Thus my initial hack code example for the specific case I ran across.

Good luck! (8^D)

• Christopher Mullins

[g1smd]

If you would like detailed validation and formatting for UK telephone numbers, you are welcome to borrow code from: https://github.com/g1smd/Drupal-CCK-Phone-GB/blob/master/phone.gb.inc

[schir1964]

Mark, I think you can close this. Unless you have solution ready to drop in.