Search found 5 matches

by NickS
Thu Mar 10, 2011 8:56 pm
Forum: XLSReadWriteII 3/4/5
Topic: How to set last column when hitting Ctrl-End
Replies: 2
Views: 3611

Re: How to set last column when hitting Ctrl-End

Hi Lars, thanks for replying.. Well, all I'm doing is taking an existing XLSv2 report and converting to the latest XLSv4 component/code. And there were a lot of code/syntax differences and one thing in the old version that worked fine was just writing a simple string/number cell with a value. But in...
by NickS
Mon Mar 07, 2011 8:23 pm
Forum: XLSReadWriteII 3/4/5
Topic: How to set last column when hitting Ctrl-End
Replies: 2
Views: 3611

How to set last column when hitting Ctrl-End

Hello, I've converted an old XLSv2 report to XLS4 and one big difference that our users need back is the ability that once they first open the Excel report and hit Ctrl-End, it takes them to the last row/column of data. The old XLSv2 did no problem, but XLSv4 does not. It does take the user to the l...
by NickS
Tue May 18, 2010 2:37 pm
Forum: XLSReadWriteII 3/4/5
Topic: How to apply a created font format to a cell?
Replies: 3
Views: 4126

Re: How to apply a created font format to a cell?

Thanks Lars! Again, in keeping with my XLS2 version program code, I would always create the XLS.Font.Add first and then XLS.Formats.Add and create an integer value to keep track of which Formats used which Font, like so: with XLS.Formats.Add do begin FontIndex := 6; HorizAlignment := chaCenter; end;...
by NickS
Mon May 17, 2010 5:29 pm
Forum: XLSReadWriteII 3/4/5
Topic: How to apply a created font format to a cell?
Replies: 3
Views: 4126

How to apply a created font format to a cell?

Since we've upgraded from XLS2 to XLS4, a lot of code syntax was "broken" by the upgrade because of so many changes. I'm very surprised no backwards compatibility! Anyways, with XLS2, you can create a new font, assign it an index and then output your string using that newly created font as...
by NickS
Wed May 12, 2010 9:11 pm
Forum: XLSReadWriteII 3/4/5
Topic: Upgraded from XLS2 to XLS4 Delphi; any help files/doc avail?
Replies: 0
Views: 2911

Upgraded from XLS2 to XLS4 Delphi; any help files/doc avail?

Hi all- Sorry to be a pain, but wondered if there was any help/.doc files written to show the syntax of some of the basic XLS2 to XLS4 statement changes? (ie. printsettings, creating fonts/formats/add row height, etc) We are converting our older XLS2 code and found that a lot of the older syntax sta...