Re[2]: [POI- HSSF] Alignment issue in sizing the Cell automatically

2007-03-23 Thread Yegor Kozlov
VK Can i keep the image irrespective of the column size? No, you can't. Image anchor defines how many cells the image occupies. If you resize columns the image gets resized too. What POI lacks is the ability to edit anchors of existing shapes. Now you can set anchor only when shape is

Re: Re[2]: [POI- HSSF] Alignment issue in sizing the Cell automatically

2007-03-23 Thread Vinay Konanki
Thanks Yegor, Ya its possible to insert after doing alignments for all columns, Its looks better now. -Vinay On 3/23/07, Yegor Kozlov [EMAIL PROTECTED] wrote: VK Can i keep the image irrespective of the column size? No, you can't. Image anchor defines how many cells the image occupies. If

Re: [POI- HSSF] Alignment issue in sizing the Cell automatically

2007-03-22 Thread Vinay Konanki
Thanks Yegor, Its working great, but getting another alignment issue with this, i used logo (image) in the excel sheet. with the auto sizing the image also expanding and contracting according to that column data. Can i keep the image irrespective of the column size? Here is the code that i used

Re: [POI- HSSF] Alignment issue in sizing the Cell automatically

2007-03-21 Thread Yegor Kozlov
Hi, The POI 3.0 RC1 can be downloaded from http://people.apache.org/~nick/POI-3.0-RC1/ HSSFSheet.autoSizeColumn was added after 12-Dec-2006. Try the latest jar. Regards, Yegor VK Hi all, VK I'm new to this group. I'm trying to generate MS Excel from my java code. VK I'ts