Language-CondionalFormat SheetRender Problem

Aspose.Cells Product Family
1

Dear Aspose Support,


please use following code with attached File:

Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(“c:\Excelbericht Filterungen OS + BS + BF.xlsx”, new Aspose.Cells.LoadOptions(Aspose.Cells.LoadFormat.Xlsx));
wb.CalculateFormula(true);
foreach (Worksheet ws in wb.Worksheets)
{
Console.WriteLine(ws.ConditionalFormattings.Count);
SheetRender sr = new SheetRender(ws, new ImageOrPrintOptions() { OnePagePerSheet = true, SaveFormat = SaveFormat.XPS });
if (sr.PageCount > 0)
{
sr.ToImage(0, “c:\test” + ws.Index + “.xps”);
}

}

If you set System Region and Language Settings to:
Format: German (Germany)
Location: Germany

Sheet 5 (BedForm) conditional format not be rendered. (it’s a 3-Color-Scale setting)

Best regards

Bernhard
2

Hi,

Thanks for using Aspose.Cells for .NET.

Please download and try the latest fix:
Aspose.Cells
for .NET v7.3.1.4 it should work fine.

I have attached the output xps file for your reference.

If you still find the problem, then please highlight it with red circles using some screenshot (s) and by comparing the input and output files.

Please see the sample test code below.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\Excelbericht+Filterungen+OS+%2b+BS+%2b+BF.xlsx”;


LoadOptions opts = new LoadOptions(LoadFormat.Xlsx);

opts.LanguageCode = CountryCode.Germany;

opts.Region = CountryCode.Germany;


Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(filePath, opts);

wb.CalculateFormula(true);

foreach (Worksheet ws in wb.Worksheets)

{

Console.WriteLine(ws.ConditionalFormattings.Count);

SheetRender sr = new SheetRender(ws, new ImageOrPrintOptions() { OnePagePerSheet = true, SaveFormat = SaveFormat.XPS });

if (sr.PageCount > 0)

{

sr.ToImage(0, “testout” + ws.Index + “.xps”);

}


}


3

Hi,


you have to change the Windows System Region and Language settings to german, please take a look on my first post.

I attached the result xps of sheet 5, nothing is formated.

Best regards

Bernhard
4

Hi,

I have compared my output and your output in a screenshot below for your reference.

As you can see, the latest version given on above post is working fine. My output xps file is formated and yours is unformatted.

We have also lately fixed the similar issue before.

Let us know if you still have any questions or facing some issue.

Screenshot:

5

Hi,


are you sure you have set the german region and language settings?

I can reproduce this issue with Version 7.3.1.4., please see screenshot.

Best regards

Bernhard
6

Hi,

Thanks for your feedback.

Could you please tell us that you are using ClientProfile NET Framework or just a regular .NET Framework?

For ClientProfile .NET Framework, we provide a separate compiled dll. So this dll will not work if your .NET Framework is ClientProfile.

Please also share you complete System Environment.

It seems, this issue appears because of different System Environment as you have shown in your screenshot, everything is right.

Please also let us know that if you can open Attachment: testout5.xps in your system fine.

We will look into your issue and help you asap.

7

Hi,


Could you remove the following lines in your code and then try if it works fine with v7.3.1.4.
opts.LanguageCode = CountryCode.Germany;
opts.Region = CountryCode.Germany;

Thank you.
8

Hi,


its regular Target Framework (.NET Framework 4).

I attached the visual studio project.

I can reproduce this on more than one systems.

What informations about system environment do you need?

Best regards

Bernhard
9

Hi Amjad Sahi,


not improvements with removing these two lines.

Best regards
10

Hi Bernhard,


We are sorry for your inconvenience and confusion.

I have logged a ticket with an id: CELLSNET-41050 for your issue. Our concerned developer will soon look into your issue. Hopefully we will get back to you soon to figure it out for your locale (German) settings.

Thank you.

11

Hi,

Thanks for using Aspose.Cells.

We have fixed your issue. We will provide you a fix after some additional testing (i.e 2~3 working days).

12

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.3.1.7 and let us know your feedback.

13

The issues you have found earlier (filed as CELLSNET-41050) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.