Picture Formatting 2

[deadballfan]

I would like to be able to set the picture property "move and size with cells" in my program. How can I do this?

M. Thomas

[larsa]

Hello

Sorry, but I can't find how the option for that is stored in the files.

[deadballfan]

See file "DrawingObj4.pas", line 1090.

M. Thomas

[larsa]

Hello

You found the answer. Is it not working?

[deadballfan]

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

[deadballfan]

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 spreadsheet as Excel 97. But he can't sort it with Excel 2010 although a spreadsheet created manually from Excel 2007 does sort the pictures along with the other line items. So, I changed the report to create the spreadsheet as Excel 2007 and renamed the file to XLSX. Now, no pictures show up on the spreadsheet. Any ideas?

M. Thomas

[larsa]

Hello

Pictures are not supported in XLSX files yet. This will be addressed in the new v5 of the component.