Page 1 of 1
Resize comments
Posted: Tue Jan 07, 2020 6:25 am
by ykarapinar
Code: Select all
XLSReadWriteII51.Filename:='C:\XLSRWII.xlsx';
XLSReadWriteII51[0].Comments.Add(1, 1, '', 'text');
XLSReadWriteII51.Write;
Hello
How can I resize comments?
Re: Resize comments
Posted: Mon Jan 13, 2020 10:17 am
by larsa
Hello
Use the Col1,Col2,Col1Offs,Col2Offs,Row ... properties of the TXLSComment.Xc12Comment object.
Re: Resize comments
Posted: Tue Jan 14, 2020 11:57 am
by ykarapinar
Hello
Can you send code example please
Re: Resize comments
Posted: Mon Feb 03, 2020 10:33 am
by ykarapinar
I couldn't find how to use it, please can you give an example of its usage?
Re: Resize comments
Posted: Wed Feb 05, 2020 8:15 am
by larsa
Hello
Code: Select all
C: TXLSComment;
begin
C := FXSS.XLS[0].Comments.Add(1, 1, '', 'text');
C.Xc12Comment.Col1 := 5;
Re: Resize comments
Posted: Wed Feb 05, 2020 10:32 am
by ykarapinar
Code: Select all
var
C: TXLSComment;
begin
XLS.Filename:='C:\XLS.xlsx';
C := XLS[0].Comments.Add(1, 1, '', 'text');
C.Xc12Comment.Col1 := 5;
C.Xc12Comment.Col2 := 8;
XLS.Write;
end;
I still can't resize. Am I missing something?
Re: Resize comments
Posted: Mon Mar 09, 2020 9:53 am
by ykarapinar
Hello
The sample code you have send is not resizing the dimensions of comments window. Can you please send a working code?