https://bugs.documentfoundation.org/show_bug.cgi?id=161836
--- Comment #5 from ady <[email protected]> --- FWIW... (In reply to Óvári from comment #4) > 2. D1 shows formula from cell A1. > (a) Is this inconsistent with the behavior of the formula bar when cell A1 > is selected? > (b) Should the value in D1 be the #N/A error value? This is an ods file, so it should follow ODF + Calc rules. If cell D1 should not show its formula or its content, then you should modify the "Cell Protection" properties of cell D1 accordingly. I would add that, in some situations, the cells that are allowed to be modified by users (i.e. not protected) should be also limited by "Validity" (or "Validation") rules. To be clear, I have not reviewed exactly how this should work (according to the ODF standard). I have not tested what happens when mixing an ods file pointing to an xlsx file, but that seems to be a different scenario anyway. -- You are receiving this mail because: You are the assignee for the bug.
