CoercionType.Matrix will not bypass "calculated columns" feature as suggested by the docs about office-js-docs-reference HOT 7 CLOSED

Hi @sameera, I assigned this to Sudhi who can verify. Can you provide the link to the documentation where you found this discrepancy? Thanks, lindalu

from office-js-docs-reference.

This NOTE appears on the following page after the remarks:
https://github.com/OfficeDev/office-js-docs/blob/master/reference/shared/document.setselecteddataasync.md

But, that note is correct, I believe for the setDataAsync method. This is more of a missing documentation for the addRowsAsync method. In Matrix mode, while the method can append rows with different formulas, each set added causes the formulas of the rows above to change to the first formula in the appended row (which is unexpected as it's undocumented).
Here's a an ani-gif showing this in effect:
https://1drv.ms/i/s!AuIKF3TQj25muDS-8Xn6NOcnwj_Y

from office-js-docs-reference.

I did some more testing and even for setDataAsync method, using Matrix (or event Text) coercionType to bypass calculated column behavior works only when you

1. write to all the cells in the column
2. the column already has different formulas.
   If you are writing to one cell of the column which is empty, which has the same formula on the entire column or few cells it, will revert back to calculated columns.

from office-js-docs-reference.

@sameera Thanks! I'll leave this for @sumurthy to follow up. We're heading into a holiday week so please be patient if it takes us a while. I'll definitely check back on this issue in a few days. lindalu

from office-js-docs-reference.

This is just the default formula column behavior - may be API needs to describe the behavior of underlying table to avoid confusion. We should log a work item to update the doc.

from office-js-docs-reference.

Transferring this issue from OfficeDev/office-js-docs into OfficeDev/office-js-docs-reference.

from office-js-docs-reference.

The documentation has been fixed in the source. It should be in the public docs in a few days.

from office-js-docs-reference.