Resize comments

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
ykarapinar
Posts: 22
Joined: Fri May 17, 2013 7:59 am

Resize comments

Post 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?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Resize comments

Post by larsa »

Hello

Use the Col1,Col2,Col1Offs,Col2Offs,Row ... properties of the TXLSComment.Xc12Comment object.
Lars Arvidsson, Axolot Data
ykarapinar
Posts: 22
Joined: Fri May 17, 2013 7:59 am

Re: Resize comments

Post by ykarapinar »

Hello

Can you send code example please
ykarapinar
Posts: 22
Joined: Fri May 17, 2013 7:59 am

Re: Resize comments

Post by ykarapinar »

I couldn't find how to use it, please can you give an example of its usage?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Resize comments

Post by larsa »

Hello

Code: Select all

  C: TXLSComment;
begin
  C := FXSS.XLS[0].Comments.Add(1, 1, '', 'text');
  C.Xc12Comment.Col1 := 5;
Lars Arvidsson, Axolot Data
ykarapinar
Posts: 22
Joined: Fri May 17, 2013 7:59 am

Re: Resize comments

Post 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?
ykarapinar
Posts: 22
Joined: Fri May 17, 2013 7:59 am

Re: Resize comments

Post by ykarapinar »

Hello
The sample code you have send is not resizing the dimensions of comments window. Can you please send a working code?
Post Reply