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

Pepijn 1 Reputation point
2021-01-14T12:26:25.377+00:00

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.

56582-2021-01-14-12-36-57-test-sheet-4xlsx.png

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

56583-2021-01-14-12-37-10-test-sheet-4xlsx.png

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.

Office Open Specifications
Office Open Specifications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
119 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Bowen 1,276 Reputation points Microsoft Employee
    2021-01-27T18:29:51.827+00:00

    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

    0 comments