<img src=Dropbox - Highlight error.png - Simplify your life>
image.png (9.9 KB)In the image above the sentence “This is a sentence in a textbox” is in both a textbox and regular cell. Using addHighlightTextBox and addHighlightText respectively, with the starting index at 24 and ending index at 31, you can see there seems to be a pixel or so that isn’t highlighted. I used the same sentence because the “x” character seems to show this better than some other characters.
@gpaolano
can you provide the sample spread sheet file.
we need to investigate more.
It can be related with font setting for the text.
below is the snapshot in my side which seems ok.
@gpaolano
I try set a large font size for the text, it still ok in my side.
There seems to be some inconsistency. Could you look at this excel? If I use addHighlightTextBox(“0”, 10, 17) (highlighting the word “textbox” in the textbox) it always seems to be off.
Otherwise, I am trying different scenarios to see if I can pinpoint why it works sometimes.
Excel.Test.00001.zip (253.1 KB)
Thanks for providing further details and the sample Excel file. We will look into it and get back to you soon.
@gpaolano
just use the latest version from npm js is ok.
<script src="https://unpkg.com/gridjs-spreadsheet@23.11.0/xspreadsheet.js"></script>
