Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Message-Id: <F694F5E8-A0DD-40F5-A310-C4ACA90ABBE0@npcinternational.com>
From: Jon Brisbin <jon.brisbin@npcinternational.com>
To: "POI Users List" <user@poi.apache.org>
In-Reply-To: <88A28197-0643-496D-A517-A76E1F816E99@jmlafferty.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v935.3)
Subject: Re: Problems adding logo image to spreadsheet
Date: Wed, 3 Jun 2009 13:59:54 -0500
References: <35ADF53A-A81E-4D2E-B6D3-303FD4B4030D@npcinternational.com>
 <23855274.post@talk.nabble.com>
 <88A28197-0643-496D-A517-A76E1F816E99@jmlafferty.com>


On Jun 3, 2009, at 12:07 PM, Dave Fisher wrote:

> Take a look at the thread starting March 18, 2009 by AKewalramani  
> and the subject of "Anchor type methods in XSSF" includes responses  
> from Yegor:
>
>>> This was easy to achieve in HSSF because  the  HSSFClientAnchor  
>>> class had a setAnchorType
>>> method which I could set a value to "2" and the image would move  
>>> with the cell and it would
>>> not resize itself as the cell size is changed.
>
> Regards,
> Dave

If I set the anchor type to "2", I still have to multiply the pixel  
height and width of my image by seemingly random values. In other  
words, if I multiply the width of my image by 5.4 and the height of my  
image by 3, I get a reasonable facsimile of the original inside my  
spreadsheet.

Besides all of this being extraordinarily non-intuitive, I did search  
extensively for example code, etc... and couldn't find anything that  
says "to insert an image into your spreadsheet, keep A, B, and C, in  
mind...", citing the above strangeness. It would seem that the POI  
developers would have documented the fact that you have know the  
secret codes to enter to get the results you're looking for,  
especially if you simply have a requirement to generate a spreadsheet  
to email to a non-technical user and you've never done that before and  
you have heard about POI only second-hand and you don't have time to  
spend digging into the source code of the thing just so you can use it  
in a small, non-critical task.

It's been a very frustrating experience so far, to say the least...

Jon Brisbin
Portal Webmaster
NPC International, Inc.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org