[Bug 161223] basic HTML cell render

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from David <dmontes at gmx.us> ---
  I will try to explain the use case we foresee for the proposed functionality.
We are a medium size structural engineering office, many time we have to
prepare complex structural reports based on results exported out of FE software
in form of spreadsheets. For the automation of the creation of documents, we
have spreadsheets we use as templates with the verification formulas of
regulations like for example Eurocodes.
  Now we have one cell for the main check with an outcome like "Ok" "NOK" and
conditional format, followed with an explanation and documental references on
next an previous cells, text format is terrible for a formal pdf exportation.

  Think of a text similar to: "as expresed on clause EN 1993 4.2.1 for class 1
cross-section, buckling check <b>fails</b> due to <b>excesive slenderness</b>
see equation 4.2.1b"

  This would be a very basic example that would be expressed into something
like:
=if(CrossSectionClass=1,"as expresed on clause 4.2.1 EN 1990 for class 1
cross-section, buckling check "&if(checkingHere,"is ok","<b>fails</b> due to
<b>"&causeOfFailureHere&"</b> see equation 4.2.1b"))
  This is the basic functionality.

  Medium functionality, if we want to go for the full package, would be a bit
more complex font formating like: <span style="text-decoration:
overline">λ</span> so we could write formulas on the conditions with
mathematical required characters.

  And the "let's-make-a-magical-wish" functionality would include <img
src="data:image/png;base64, ...> so you could even put different figures based
on the conditions or in the middle of text explanations.

  As I said from the beginning simple text format html tags would be very
useful for complex format conditions or conditional format in middle
paragraphs. I think in html tags as they are near universal, but of course
other format marks would be also useful.
  Medium functionality and "let's-go-crazy" functionality I know are just
dreams :-)

Hope it clarifies the request.

BR

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