Axolot Data

I have version 5 and am using Delphi XE2.
I need to print just a selected area and also need to include page numbering in my footer. Can you tell me how to do this, or point me to documentation for this?
Thanks,'
Marshall Thomas

Totally my fault. I had a bad installation and didn't realize it. Lars' response was spot on. I can now sort the pictures along with the rest of the data.

Thanks for your help,
Marshall Thomas

If you are referring to the source code above, I was unable to get it to compile. Perhaps I'm missing something.

Sorry to be such a bother,
Marshall

Could someone please explain how to use EditImage?

Thanks,
Marshall

Sorry, but I'm having a problem getting this to compile: var PicImage: TXLSDrawingImage; EdImage : TXlsDrawingEditor; iRow : integer; sPicfile : string; begin iRow := 1; sPicfile := 'test.jpg'; PicImage := XLS1.Sheets[0].Drawing.InsertImage(sPicfile,0,iRow,0.1,0.1,0.10); EdImage := XLS1.Sheets[0].Dr...

Is there a way to programmatically change the height and width of a picture after it has been inserted?

Marshall

First, the picture is always larger than the cell. I place the picture in the cell using col offset and row offset. No problem with keeping the photo from touching the left cell border or the top cell border. But the picture always touches the right cell border and the bottom cell border. If I then ...

Positive numbers always make the picture offsets on the right and bottom cross the cell borders. I need the picture to fall just short of the right and bottom sides.

Marshall

Thanks, but this isn't quite what I need. I need to have the picture (and these are somewhat large pictures) shrink down to a size that fits the overall spreadsheet. I am increasing the height and width of the respective cells, but in order to keep the picture within say Column 0, Row 1 I have to us...

I create a spreadsheet for a client that displays a product picture in one of the columns. This works great but he wants to be able to sort the spreadsheet and keep the pictures with the data. I have already set the positional property of the picture to "move and size". I have found that t...

How do you change the row height after adding a picture? I cannot find a function similar to setRowHeight.

M Thomas

Are pictures now supported in XLSX files?

Marshall Thomas

I got it to work by assigning True to MoveWithCells when adding each picture. So, this solves one problem. Now, my client can re-size his rows without problem. But now we still have the sort problem. He can sort the created spreadsheet with Excel 2003 with no problem. I am currently creating the spr...

I thought this was it, but wasn't sure. I didn't really want to change your source code, but figured if this were really the answer that you could show me how to access this from my source code.

M. Thomas

See file "DrawingObj4.pas", line 1090.

M. Thomas