https://bugs.documentfoundation.org/show_bug.cgi?id=115431
--- Comment #4 from Mike Kaganski <[email protected]> ---
(In reply to m.a.riosv from comment #3)
Yes - the F11 cell does contain a formula, and current values in referenced
cells must give a numerical values.
Still the OOXML has this for the F11:
> <c r="F11" s="25" t="str">
> <f
> aca="false">IF((C11&D11)="","",(D11-C11-7))</f><v>1.00</v>
> </c>
where the 't="str"' part makes it a textual cell. On opening the file, unless a
recalc is required (either way mentioned by m.a.riosv), cached values are used
(which is OK).
However, the question is, from where and how the cell was marked as text
originally. Maybe that's the real bug, but the document doesn't give a way to
see that. Maybe there's some original document, and steps to reproduce it?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
