1. Home
  2. Forum
  3. WPF
  4. Spreadsheet Control is not showing worksheet background Image.

Spreadsheet Control is not showing worksheet background Image.

We had watermarked Excel worksheet by setting background image as given below

System.Drawing.Font font = new System.Drawing.Font("Arial", 24);
var watermarkImage = TextToImage(watermarkText, font, System.Drawing.Color.LightGray, System.Drawing.Color.Transparent, -45);
for (int workSheetIndex = workbook.Worksheets.Count - 1; workSheetIndex >= 0; workSheetIndex--)
{
   Syncfusion.XlsIO.IWorksheet sheet = workbook.Worksheets[workSheetIndex];
   sheet.PageSetup.PrintComments = Syncfusion.XlsIO.ExcelPrintLocation.PrintSheetEnd;
   sheet.PageSetup.BackgoundImage = watermarkImage;

}

But when same workbook is loaded into Spreadsheet control, it is not showing background image.

When exporting same workbook to excel file, and open in MS Excel, I can see background image.

Sample output file is shared as reference, which is fine as per our requirement. We are expecting same in Spreadsheet control.



Attachment: sampleWatermarked_c82dee71.zip


4 Replies
DM Dhanasekar Mohanraj Syncfusion Team April 18, 2022 02:16 PM UTC

Hi Kamran,

We regret to inform that the provided details are not enough to replicate the reported issue in our end. Could you please share the entire code blocks related to SpreadSheet (WPF and C-Sharp). If possible, please share the issue reproducing sample. It will be more helpful for us to find the exact cause and provide you the prompt and timely solution.

Regards,
Dhanasekar M.


KA Kamran replied to Dhanasekar Mohanraj April 19, 2022 01:42 PM UTC

Dear Team,

I had already attached the sample excel document. Reported issue can be reproduced in Syncfusion wpf control panel demo. You can open attached file in spreadsheet control demo, or import it.


Expected result:  (WPF .Net core 19.4.0.38)

Excel sheet opened successfully, but missing background image. Following images for reference. 



and here is spreadsheet control result




DM Dhanasekar Mohanraj Syncfusion Team April 20, 2022 03:28 PM UTC

Hi Kamran,


We can able to reproduce the reported issue in our end. We will check this and update you further details on April 22, 2022.


We appreciate your patience until then. 

Regards,
Dhanasekar M.


DM Dhanasekar Mohanraj Syncfusion Team April 22, 2022 04:05 PM UTC

Hi Kamran,

Currently, SpreadSheet does not have a support for showing background image. We have analyzed and considered your requirement of “Support to import worksheet background image in spreadsheet” and logged feature request for the same. We will implement this feature in any of our upcoming release.


At the planning stage for every release cycle, we review all open features and identify features for implementation based on specific parameters including product vision, technological feasibility, and customer interest. We will let you know when this feature is implemented. We appreciate your patience until then.


Thank you for requesting this feature and helping us define it. We are always trying to make our products better and feature requests like yours are a key part of our product growth efforts.


Feedback link: https://www.syncfusion.com/feedback/34384/support-to-import-worksheet-background-image-in-spreadsheet


If you have any more specification/suggestions to the feature request, you can add it as a comment in the portal and cast your vote to make it count.


Regards,
Dhanasekar M.


Loader.
Up arrow icon