jquery-table2excel icon indicating copy to clipboard operation
jquery-table2excel copied to clipboard

when table content having phone no then excel sheet don't show it properly

Open amitjoc opened this issue 6 years ago • 1 comments

my table having phone no in the format +91-9999999999

but when exported then it show it wrong inside the excel sheet like -9999999999

but when i click the cell in formula bar it shows the =91-9999999999

amitjoc avatar Dec 07 '18 11:12 amitjoc

By US standards, that's not a phone number, and to excel it would look like a partial formula, "+ 91 - 999999999".

The only thing you can do right now is update the format in Excel after opening. Long term, we have to figure out a way to decorate and parse format in with other such features.

rainabba avatar Dec 07 '18 13:12 rainabba