Problem with cell comment lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- kjteng · 2025-01-15 13:17 I have problem with the following code:- the hint string (tx) is saved properly and can be displayed with showmessage(tx). However it is truncated (only show 'abc' ) when the hint is displayed (on mouse over the particular cell) :-     ws.WriteComment(0, 1, 'abc | 12345');     tx := ws.ReadComment(0, 1);     showmessage(tx);    How can I solve this ?  TQ in advance ---------------------------------------------------------------------- wp · 2025-01-16 13:40 The pipe character '|' has a special meaning in the LCL - it splits the popup hint text into two parts, a "short" part for the popup and a "long" part for the status bar. Since the worksheet grid displays the comment via the Hint property, it is affected by this feature. It can be avoided when the '|' is replaced by a unicode character looking similarly: In unit fpspreadsheetgrid, function TsCustomWorksheetGrid.GetCellHintText(...), add the following code: Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i   [...]  // Read comment  comment := Worksheet.ReadComment(cell);   if pos('|', comment) > 0 then                                             // <--- ADD    comment := StringReplace(comment, '|', #$E2#$94#$82, [rfReplaceAll]);   // <--- ADD   // Read hyperlink info  if Worksheet.HasHyperlink(cell) then begin  [...]  Or use the svn version of fpspreadsheet which was fixed in r9591. ---------------------------------------------------------------------- kjteng · 2025-01-17 03:37 thank you very much Master.