https://bugs.documentfoundation.org/show_bug.cgi?id=98481
Eike Rathke <er...@redhat.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
Assignee|libreoffice-b...@lists.free |er...@redhat.com
|desktop.org |
--- Comment #11 from Eike Rathke <er...@redhat.com> ---
So, actually Google got this wrong, the 't' attribute indicates the cell's data
type, which is of the cell value (<v> element), not the formula string (that is
the <f> element) but the formula result.
See ECMA-376
18.3.1.4 c (Cell)
18.18.11 ST_CellType (Cell Type)
Excel uses t="str" for a formula result string, that is not a formula string
... probably because t="s" could not be used because the result string is not a
shared string, and with t="inlineStr" the <v> element could not be used for the
result but an <is> element instead but formulas can't return rich strings ...
That's totally f*cked up.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs