[Bug 167017] In-cell pictures

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Jun 19 19:15:06 UTC 2025


https://bugs.documentfoundation.org/show_bug.cgi?id=167017

--- Comment #4 from Regina Henschel <rb.henschel at t-online.de> ---
(In reply to Heiko Tietze from comment #2)
> The file opens in Calc with #VALUE!, "Place Over Cell" does show the image.

The content #VALUE! is for those applications, that are not able to interpret
the value metadata.

> 
> The attribute works like anchoring to a cell plus fit to cell. The "image
> handle" are actually cell handle and duplicates the cell when dragged. The
> image size changes with col/row width/height (always keeping the aspect
> ratio). Formulas like =A1 copy the content image.

The image replaces the cell content in Excel, whereas anchoring to cell and
applying uno:FitCellSize keeps the content. The concept in Excel belongs to its
CUBE-foo functions. The specification of the used "Value Metadata" feature is
in chapter 18.9 of the OOXML spec part 1.

I do not consider it as new type of "anchor", what Excel does here.

> Not sure if this requires an addition to ODF.

It might be that it is possible to use the attributes xhtml:about (19.911),
xhtml:content (19.912), xhtml:datatype (19.913), xhtml:property (19.914). They
are related to RDF (https://www.w3.org/TR/rdf11-concepts/). But I have
absolutely no idea about RDF.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list