jx:image tag has a scale error.

[akaLogan]

When I using the jx:image tag like this-> ' jx:image(lastCell="xxx" src="xxx" scaleX="1.0" scaleY="1.0") ', threw a exception that message like this:

### Then I continue checked source code of Jxls, found that when scaleX and scaleY is not null, the method named 'addImage' in PoiTransformer set Anchor's col2 and row2 value to -1.

But in the HSSFClientAnchor.java of Apache'Poi, it will check col2 to make sure that col2 value not smaller than 0.

That is a conflict with the 'addImage' method in PoiTransformer.java and caused exception like I said.

So, somebody know how to fix that problem? Or maybe I was uesd this image tag with a incorrect way, please just tell me, I will appreciate that.

[SoltauFintel]

Looks to me like an Apache POI XLS bug that has to be reported by you at the POI community.

I guess it will work if you use XLSX.

XLS = HSSF = old format, XLSX = XSSF

[akaLogan]

Thank for help, it was worked. But there still some problem, the picture has been resized to same as first cell size. How can I do to keep picture original size? @SoltauFintel

[akaLogan]

Hello @SoltauFintel , You still here?

[SoltauFintel]

I have no experience with JXLS and images. So you'd have to wait for someone else to reply or do your own research. :-)

[akaLogan]

All right, Thanks