[WOPI] Cells displayed incorrectly with "Accounting Number Format" styling applied. "RestrictedWebViewOnly" issue.

Question

[WOPI] Cells displayed incorrectly with "Accounting Number Format" styling applied. "RestrictedWebViewOnly" issue.

Pepijn 1

We've noticed an issue with displaying cells in read only mode.
Cells using "Accounting Number Format" styling are not displayed correctly.

What we do is set ReadOnly and RestrictedWebViewOnly in CheckFileInfo to true.
When the file is loaded it wrongly displays ###### instead of the actual value. You can click on the cell and see the actual value inside the formula bar, but there it also has the currency symbol which is not shown when viewing the cell in Excel application or loading the file with RestrictedWebViewOnly set to false.

The only way to view the contents of the cell is by adjusting the width to an extreme value. For example a width of 1000 pixels is needed to display a value of 4.00

When loading the file with "RestrictedWebViewOnly = false" then everything works as expected.

Is there a known issue with this formatting type or custom formats in general when loading an Excel file as read only/RestrictedWebViewOnly?

We were able to reproduce this issue on Sharepoint/OneDrive when sharing Excel workbooks with with the “Read-only” and “Block download enabled” parameter set.

Mike Bowen 2,051 Reputation points Microsoft Employee Moderator

2021-01-14T17:10:44.127+00:00

Hi,

Thank you for your question. One of our engineers will respond soon.

Mike Bowen

Escalation Engineer - Microsoft Open Specifications
Mike Bowen 2,051 Reputation points Microsoft Employee Moderator

2021-01-14T20:32:22.77+00:00

Hi Pepijn,
Can you share a file that has this display issue or give repro steps on how to create an Excel file that shows this error?

Thanks,

Mike Bowen

Escalation Engineer - Microsoft Open Specifications
Pepijn 1 Reputation point

2021-01-15T09:43:47.047+00:00

Hi Mike,

Thanks for your response!

Of course.
Repro file: https://file.io/ANAztct7eMnf
Columns F and H are affected due to number formatting style set to "Accounting".
That's how you can create an Excel file with the same error, just apply number formatting "Accounting" to any column or cell.

Best,
Pepijn
.
Mike Bowen 2,051 Reputation points Microsoft Employee Moderator

2021-01-16T02:44:21.697+00:00

Hi Pepijn,

I'm not seeing the same formatting issues when I open this file. Can you send me the build of WOPI that you're using, your checkFileInfo response, and a fiddler trace of the request.

Thanks,

Mike
Pepijn 1 Reputation point

2021-01-18T11:57:59.687+00:00

Hi @Mike Bowen ,

Please find here: https://www.dropbox.com/sh/9ywt33luvcjz5as/AADTHDuBA0vcVYyxmF1Wm6Vza?dl=0

CheckfileInfo and fiddler trace

Screen recording of full repro on Sharepoint / Office online

We use WOPI for Office Online so not sure to which build you refer. We use the following URLs: https://wopi.readthedocs.io/en/latest/build_test_ship/environments.html?highlight=prod#wopi-discovery-urls

Thanks!
Pepijn 1 Reputation point

2021-01-22T09:45:01.62+00:00

Hi @Mike Bowen ,

I wonder if there are any updates from your side?
Is my additional info sufficient?

Thanks!
Mike Bowen 2,051 Reputation points Microsoft Employee Moderator

2021-01-27T16:49:22.567+00:00

Hi @Pepijn , I'm still working on getting this to repro. The build I'm referring to is the build of Office Online Server you're using with your WOPI implementation.

Best,
Mike Bowen

1 answer

Your answer

Mike Bowen 2,051 Reputation points Microsoft Employee Moderator

2021-01-14T17:10:44.127+00:00

Hi,

Thank you for your question. One of our engineers will respond soon.

Mike Bowen

Escalation Engineer - Microsoft Open Specifications
Mike Bowen 2,051 Reputation points Microsoft Employee Moderator

2021-01-14T20:32:22.77+00:00

Hi Pepijn,
Can you share a file that has this display issue or give repro steps on how to create an Excel file that shows this error?

Thanks,

Mike Bowen

Escalation Engineer - Microsoft Open Specifications
Pepijn 1 Reputation point

2021-01-15T09:43:47.047+00:00

Hi Mike,

Thanks for your response!

Of course.
Repro file: https://file.io/ANAztct7eMnf
Columns F and H are affected due to number formatting style set to "Accounting".
That's how you can create an Excel file with the same error, just apply number formatting "Accounting" to any column or cell.

Best,
Pepijn
.
Mike Bowen 2,051 Reputation points Microsoft Employee Moderator

2021-01-16T02:44:21.697+00:00

Hi Pepijn,

I'm not seeing the same formatting issues when I open this file. Can you send me the build of WOPI that you're using, your checkFileInfo response, and a fiddler trace of the request.

Thanks,

Mike
Pepijn 1 Reputation point

2021-01-18T11:57:59.687+00:00

Hi @Mike Bowen ,

Please find here: https://www.dropbox.com/sh/9ywt33luvcjz5as/AADTHDuBA0vcVYyxmF1Wm6Vza?dl=0

CheckfileInfo and fiddler trace

Screen recording of full repro on Sharepoint / Office online

We use WOPI for Office Online so not sure to which build you refer. We use the following URLs: https://wopi.readthedocs.io/en/latest/build_test_ship/environments.html?highlight=prod#wopi-discovery-urls

Thanks!
Pepijn 1 Reputation point

2021-01-22T09:45:01.62+00:00

Hi @Mike Bowen ,

I wonder if there are any updates from your side?
Is my additional info sufficient?

Thanks!
Mike Bowen 2,051 Reputation points Microsoft Employee Moderator

2021-01-27T16:49:22.567+00:00

Hi @Pepijn , I'm still working on getting this to repro. The build I'm referring to is the build of Office Online Server you're using with your WOPI implementation.

Best,
Mike Bowen

Answer 1

Mike Bowen 2,051 Microsoft Employee Moderator

Hi @Pepijn ,
You mentioned you use WOPI for Office Online, however the openspecs-office tag is for questions about Office Online Server product deployments, not Office for the Web (formerly known as Office 365) product (cloud). For Office for the Web integration questions please direct your posts to the Yammer group provided by the Cloud Storage Partner Program. For more information on that program, please refer to Office Cloud Storage Partner Program.

Best,
Mike Bowen

Share via

[WOPI] Cells displayed incorrectly with "Accounting Number Format" styling applied. "RestrictedWebViewOnly" issue.

1 answer

Your answer