Hi,

I have created an application that takes a spreadsheet, amends some values on a worksheet, and then makes images of some charts and cell ranges found on other worksheets.

It seems to work fine (thanks to aspose), but one (more) last issue is that cells that have been merged across a number of rows and columns aren't copied to the image correctly.

I have attached an example.

Any assistance would be appreciated.

Cheers,

Steve

Hi Steve,

Thank you for considering Aspose.

Well, I tested SheetToImage Conversion using your provided template file and it works fine (see the attach image file). Please try the attached latest version and if you still face the problem, please share your code (or a sample application) and we will look into it soon.

Thank You & Best Regards,

Hi there,

Thanks for the suggestion- I will try the latest cells hotfix, and get back to you if I still have problems.

On a related issue, if an excel bar chart uses gradient colours for the bars, and this is then saved as an image, the resultant image loses the gradient, and just uses solid colors.

Is this to be expected, or am I doing something wrong?

Cheers,

Steve

Hi Steve,

Thank you for considering Aspose.

I tried your mentioned scenario a bit and the gradient bar chart converts fine. Please try the fix provided in the previous post and if you still face this problem, please share your template file and we will check it soon. Also, please find the attached template and output image files for your reference.

Thank You & Best Regards,

Hi,

Sorry for the delay- just got back to the project!

I'm still having problems with the gradient fill not copying over.

Looking in my code, I wonder if the problem is with:

Dim oRangeDestination As Range

Then the range 'oRangeDestination' is used to create an image. Could the problem lie with CopyStyle perhaps?

Thanks,

Steve

Hi Steve,

Thank you for your feedback.

I checked your mentioned issue regarding the conversion of merged cells to image and it works fine. Please create a sample application to reproduce the issue and post it here. This will help us figure out the issue soon.

Thank You & Best Regards,

Hi,

the problem I've been having is with charts and cells using gradient fills for the background- not the merged cells problem.

Sorry for confusing you- it seemed easier to add the gradient problem onto the end of the merged cell thread I was already involved in :)

Cheers,

Steve

Hi Steve,

Thank you for considering Aspose.

Please share your complete code (may be create a sample application and post it) to reproduce the issue. This will help us figure out the issue soon.

Thank You & Best Regards,