w.Pictures.Add with offset in new columns fails

Aspose.Cells Product Family
1

Hi Laurence, its been a while. Hope you are well.

We have a slightly urgent issue with adding a picture object to a worksheet under this condition.

a. using an offset, pic.left = offset (s.t. offset is greater than zero)
b. when the column is greater than the number of columns that the worksheet had at Open().
c. version 4.3.0.0

It looks like its because the column width is not accurate using the API on new columns - even if I place a text value in the same column, it fails. The properties of columns.list look differently for those new columns - I see a lot of -1 values where the original columns look like they have well defined values like the column width in units.

I know you’ve seen this error before but maybe this one is new because I’m inserting a picture on a “new column”.

Any ideas ? Workarounds ?

thanks
Marty Spallone

p.s. hope you are well - nice job you guys!

2

Hi,

Is pic.left greater than the width of column?

Could you post your template file ,created file and the file you want to created? We will check them soon.

3

Hi Warren, thanks for the quick reply. The pic left is okay. Its less than the width. I can send you the template tomorrow.