Excel (xlsx) preview in Mail app - wrong formatting

Question

Excel (xlsx) preview in Mail app - wrong formatting

Hello everyone,

the Excel preview of iOS Mail app doesn't display Excel (xlsx) files correctly, which have been exported via Microsoft Reporting Services.

Those Excel files seem to get a special formatting from Reporting Services.

e.g. "0.0 %" is "[$-en-CA, 1]0,0 %" in the exported xlsx file.

And this can't be read by the Excel preview. There is [$-en-CA, 1] in front of every format.

Mail app Excel preview:

0% is supposed to be 8.0 % (0.081xxx)

24,138.78 is supposed to be 24,139

When I open this file in Excel on WIndows you see this formatting:

Can this be fixed?

Thank you very much in advance.

Best regards,

Anna

Gepostet am 22. Jan. 2020 13:06

Antworten

Answer 1

28. Jan. 2020 02:28 als Antwort auf anna58

https://discussions.apple.com/thread/251080271

Antworten

Answer 2

24. Jan. 2020 23:23 als Antwort auf anna58

Hello, Anna!

Thanks for posting your question in the Apple Support Communities. We have a Community for English speakers here. Please feel free to join and post your question there, or repost your question in German here.

Have a great day!

Antworten

Answer 3

25. Jan. 2020 07:41 als Antwort auf anna58

Hello Anna58,

I think your problem depends on different Code-Pages used by the OSs. Windows uses ISO-8859-1, iOS maybe uses UTF-8. You should try to synchronize.

Good luck

ervau

Antworten

Answer 4

28. Jan. 2020 02:20 als Antwort auf ervau

Hello,

thanks for the answer.

It's not a codepage issue. The Excel files look good in the Excel App.

The excel preview of iOS Mail App doesn't support the custom formatting that Microsoft Reporting Services adds to the exported Excel files.

I've uploaded an Excel file that was exported via MS Reporting Services.

https://gofile.io/?c=pC3zDv

Column C2 in Excel App: 7,63 €

Column C2 in iOS Mail App Excel preview: 7,632

Excel formatting: [$-de-DE,1]#,##0,00 €

The real trouble are percentages. 0,08 becomes 0%.. so in a business report you see 0%, -0% in all lines.

The bold part is something MS Reporting Services adds to the formatting and I've already asked for a way to disable this behaviour of MS Reporting Services in MS forums.

But still, it would be nice if the Excel preview of iOS Mail App could support these formats.

Antworten

Excel (xlsx) preview in Mail app - wrong formatting

Ähnliche Fragen