HTML reserved characters
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
fmolina · 2020-07-13 02:19

Hi,
Sorry if this a silly question. How to write "<" in a cell? I mean
programmatically, Grid.Worksheet.Cells[c, r] := ...
I know that this is a html reserved char, but I tried several ways
with &lt with no success. By the way, is there a reference of the html
subset implemented in TsWorkSheetGrid?
Thanks

----------------------------------------------------------------------
trev · 2020-07-13 02:43

Did you check the requirements for using HTML? See the Wiki article
FPSpreadsheet.

----------------------------------------------------------------------
dsiders · 2020-07-13 03:11

Quote from: fmolina on July 13, 2020, 04:19:35 amHi,
Sorry if this a silly question. How to write "<" in a cell? I mean
programmatically, Grid.Worksheet.Cells[c, r] := ...
I know that this is a html reserved char, but I tried several ways
with &lt with no success. By the way, is there a reference of the html
subset implemented in TsWorkSheetGrid?
Thanks


It's appears to be a subset of HTML 4/5. Looking at the source in
fpshtml.pas:

Code: HTML5  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i <A></A><B><
/B><BR></BR><BR/><DEL></DEL><DIV></DIV><EM></EM><FONT></FONT><H1></H1>
<H2></H2><H3></H3><H4></H4><H5></H5><H6></H6><I></I><INS></INS><P></P>
<STRONG></STRONG><S></S><SUB></SUB><SUP></SUP><SPAN></SPAN><U></U><TAB
LE></TABLE><TR></TR><TH></TH><TD></TD><BODY></BODY> 
Notable omissions:

Code: HTML5  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
<UL><OL><DL><LI><DT><DD><IMG><THEAD><TBODY><TFOOT>
As for the original question, have tried using the HTML convention?

Code: HTML5  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
&amp;lt;&amp;gt;

----------------------------------------------------------------------
fmolina · 2020-08-10 19:10

Hi, returning to the question, for "<" this does not work. It works
however for other characters, for example
Quote&amp;leqShows the 'less than or equal' char.

----------------------------------------------------------------------
fmolina · 2020-08-10 19:20

More info:
I have a combobox in a column which has the item list '-,<,≤'; when
the second item is selected, nothing is written in the cell; the other
two symbol work ok.

----------------------------------------------------------------------
wp · 2020-08-10 20:09

Quote from: fmolina on July 13, 2020, 04:19:35 amwith &lt with no
success. You're lacking the final semicolon: &lt;

The html is the worksheetgrid is meant to provide a way to directly
enter individual character formatting which Excel calls "rich text".
The corresponding html tags are queried in procedure
TsHTMLAnalyzer.TagFoundHandler of unit fpsHTMLUtils:

Quote<b>, <strong> -- bold
<br>, <br /> -- line break
<s>, <del> -- strikeout fount
<em>, <i> -- italic font
<font ...> -- font-family, face, font-size, size, color, font-style,
font-decoration, font-weight
<u>, <ins> -- underline font
<sub> -- subscript
<sup> -- superscriptHTML entities are listed at the top of the
implementation section of this unit.

----------------------------------------------------------------------
fmolina · 2020-08-11 14:52

Thank you!