Header footer regression issue with v7.4.2.3

Hi team,


We are facing one regression issue with aspose cell v 7.4.2.3,

Header footer are repeated in generated excel sheet.

Please find attached excel sheet and image with problem area marked in red color.

Please check and let me know.

This case occurring when columns are less in numbers.

Thanks,
Nakul

Hi,


Thanks for providing us the sample file.

Could you paste your code (runnable) or attach a sample console application (you may zip it prior attaching) here with the latest fix/version Aspose.Cells for .NET v7.4.3.1. Also, attach your input file if you have any, we will check your issue soon.

Thanks

Hi Amjad,


This is regression issue from aspose Cell.!!! With GetMergedRange function…

We are using aspose cell v7.3.0.2 and we are trying to use latest Aspose cell dll for few fixes provided by aspose team. But we find regression in every release of aspose cell since last 4 months.

In v7.3.0.2 we are getting correct return values of function, below function returns Range object even though excel has less than 8 rows.
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;background:
yellow;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>workBook.Worksheets[0].Cells[row,column].GetMergedRange();
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;background:
yellow;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>
In case of columns less than 8 we get NULL Range object with version 7.4.3.1. And if excel has more than 8 columns we get Range object as return value from above function.

This is breaking change and we get regression in every Aspose Cell since last 4 releases.

We are expecting quick turnaround from aspose team so that we can integrate in our code.
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;background:
yellow;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;background:
yellow;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>-Nakul
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;background:
yellow;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;background:
yellow;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;background:
yellow;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>
<span style=“font-size:12.0pt;font-family:“Times New Roman”,“serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;background:
yellow;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:
AR-SA”>

Hi,


Thanks for providing further details.

Well, we are not completely sure about your issue. And, unless we have your sample project to reproduce the issue on our end, we cannot evaluate your issue precisely. We request you to kindly create a sample console application (runnable), zip it and post it here with the latest fix/version of the product to show the issue. Also, attach your input file if you have any, we will check your issue soon.

Thank you.

Here are files for testing.


You will need to check same code with v 7.3.0.2 and v7.4.3.1.

I have done this check from my side i get NULL Range object with new version.

And get an object with old version.

Sample code (It was simple you could have written at your end also !!!)

Workbook wb = new Workbook(@“F:\Log\tests8cols.xlsx”);
var range = wb.Worksheets[0].Cells[0, 0].GetMergedRange();
if (range == null)
{
Console.WriteLine(“NULL object”);
}
Console.ReadKey();

Thanks and Regards,
Nakul

Hi,


Please download and try our latest fix/version: Aspose.Cells for .NET v7.4.3.4 it works fine.

I have tested your scenario using your template file and code, it works fine. The Range object is not null rather “A1:C1” which is fine.

Thank you.

Hi Amjad,


If you read my previous post, i have mentioned that with more than 8 cols dll works fine…\

The issue which i was pointing with less than 8 columns.

You can reproduce the issue with tests3cols.xlsx.

I am still getting same issue with v7.4.3.4 .

-Nakul

Hi,


Well, this is not an issue by any means. For your lines of code with your file “tests3cols.xlsx”:

Workbook wb = new Workbook(@“F:\Log\tests3cols.xlsx”);
var range = wb.Worksheets[0].Cells[0, 0].GetMergedRange();

there is no merged range of cells for A1 cell, you may check it in MS Excel manually opening your template file. So, Aspose.Cells correctly gives null Range which it should.

Thanks for your understanding!

Thanks Amjad,


Issue was in old aspose dll which was causing this issue.

We corrected our code as per new dll fixes.

Regards,
Nakul

Hi,


Good to know that you have sorted it out your issue now.

Feel free to contact us any time if you have further query or issue, we will be happy to assist you soon.

Thank you.