Page 1 of 1
Picture Formatting 2
Posted: Tue Sep 11, 2012 9:08 pm
by 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
Re: Picture Formatting 2
Posted: Fri Sep 14, 2012 7:05 am
by larsa
Hello
Sorry, but I can't find how the option for that is stored in the files.
Re: Picture Formatting 2
Posted: Fri Sep 14, 2012 9:21 pm
by deadballfan
See file "DrawingObj4.pas", line 1090.
M. Thomas
Re: Picture Formatting 2
Posted: Sat Sep 15, 2012 9:37 am
by larsa
Hello
You found the answer. Is it not working?
Re: Picture Formatting 2
Posted: Mon Sep 17, 2012 7:00 pm
by 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
Re: Picture Formatting 2
Posted: Wed Sep 19, 2012 5:29 pm
by 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
Re: Picture Formatting 2
Posted: Thu Sep 20, 2012 11:05 pm
by larsa
Hello
Pictures are not supported in XLSX files yet. This will be addressed in the new v5 of the component.