Axolot Data

Hi, Is there a way to append html text without overwrite the existing content. Code as below, It will only show b.html content. a.html will be gone. DOCX.Editor.AppendHTMLText('a.html'); DOCX.Editor.AppendHTMLText('b.html'); Any way to append to the bottom on Editor and keep editing? I am using TDOC...

I want to find the 'Tag string', then replace the Tag string with Para Bullet. I cannot location the cursor to the "Tag String', any idea? DOCX.Editor.Selections.Clear; DOCX.Editor.FindReplace.BeginFind('Tag string'); // What code for the cursor to point at the search tag index? // Start bullet...

Hi,

Is there a way to print the sheet of TXLSSpreadSheet direct to printer?

Thank you very much!

Thanks!

I tested, it only accept 1 format, right?
when I apply this '<b><u>GENERAL DESCRIPTION:</u></b> '

I only got underline applied.

Thank you very much!

Hi, I am able to change the format of the whole cell.

How to change the format inside the cell? I want to BOLD some words in the cell, not all the words within that cell.
Eg:
Cell 1,1 contains below.
(bold Description): TEST
(bold Model): ABC

Dear Support,

How to input multiple lines text into a single cell? Normally in MSExcel, I click Alt-Enter to next row.

Is there any replacement for this task?

Dear Support,

I am able to insert plain text into word doc.
Para.AppendPlainText(CHPX, Tmemo.text );


Is there a way to insert RICHTEXT content? the content from a Trichedit.
And keep the formatting?

Thank you very much!

Dear Support, When I focus on a cell, and press "tab", it won't jump to next cell. 1) How to set "Tab" key press and goto next cell? When I input value into a cell, it will always append to the old value. Say: I have a cell R1,C1 value is '1234', then I focus on it and start inpu...

Dear Larsa, Still not work, event I just pull XSS.XLS[0].AutoWidthCols(0,100); Is there anyway that I can set the width of all column. I tried XSS.XLS[0].Columns[0].CharWidth := 200; XSS.XLS[0].Columns[0].PixelWidth := 200; The width of column no have effect. Also, tried xss.Repaint; XSS.InvalidateS...

Dear Support, I try to set the col width to auto. But it never works. Do you have any example code for "AutoWidthCols"; My code: First column - fix width to 200. XSS.XLS[0].Columns[0].CharWidth := 20; XSS.XLS[0].Columns[0].PixelWidth := 200; The other column - autowidth. XSS.XLS[0].AutoWid...

Dear Support,

When I click on "DEL" button on a cell or selected cells in TXLSSpreadSheet, it will removed the content and formatting.

Is there anyway to prevent this? I need the formatting will always stay the same.

thank you very much!

I have problem on read the merge cell value.
Merge cell (A1,B1) and assigned a value to it.I can get value using XLS[0].Asstring[0,0] but not XLS[0].Asstring[1,0]
since cell [1,0] is already merged.

Is there any way to read merged cell value?

thanks.

Got it, Thank you very much!

Dear Axolot,

How to make the cell readonly or write protect? Not allow user to change the value of specif cell.

best regards,
Max

Dear Support,

I am able to load the image and insert into XLS SHEET.
var Image: TXLSDrawingImage;
Image := XSS.XLS[0].Drawing.InsertImage( 'resource\psd-icon.png' ,1,1,0,0,1.25);

But I tried to use TMemoryStream it have error.

Do you have an example that load from stream?

thank you very much!