ODS - Whitespace / NewLines removed

Aspose.Cells Product Family
1

Hello,

I found two minor bugs. Please have a look at my attachment (NUnitDate.zip).

Bug at C32 - Whitespace is removed

Behaviour opened with Excel 2016 (Expected results)
Value: “bitte klicke hier”
Type: Hyperlink
Url: http://www.bing.de

Behaviour opened with LibreOffice Calc
Value: “hier”
Type: Hyperlink
Url: http://www.bing.de

Cells Behaviour
Value: “bitte klickehier”
Type: Hyperlink
Url: http://www.bing.de

Bug at A30 - NewLines are removed

Behaviour opened with Excel 2016 (Expected result)
Value: “⊃∆µ\n\n £✓✗\n\n →↔↑”

Behaviour opened with LibreOffice Calc (Expected result)
Value: “⊃∆µ\n\n £✓✗\n\n →↔↑”

Cells Behaviour
Value: “⊃∆µ\n£✓✗\n→↔↑”

Thank you!

2

@mservdev

Thanks for using Aspose APIs.

We have checked your zip file, it contains only two .cs files. i.e.

  • Program.cs
  • DateTimeTests.cs

There is nothing in Program.cs and we executed the code of DateTimeTests.cs and it yielded correct results. Please also see the screenshot below.

C#

Workbook workbook = new Workbook(@"WrongDateTime.ods");
workbook.CalculateFormula();

var cell = workbook.Worksheets[0].Cells["C3"];

string s = "8:15:00 PM";

bool n = s == cell.DisplayStringValue; //<<<<<< This yields true which means OK

Screenshot:

3

Sorry for the confusion the example is taken from my other post because it has the same file that describes my problem. So please ignore the unit test in it. When I download the ZIP file, do I have more to choose from?

Please look at NUnitDate.zip\BugDemo\WrongDateTime.ods

Now you can hopefully see the behavior. The read the value I used DisplayStringValue.

Thank you.

4

@mservdev

Thanks for your clarification. We are able to observe these issues and logged them in our database for investigation and for a fix. Once, these issues are resolved or we have some other news for you, we will update you asap.

These issues have been logged as

  • CELLSNET-45995 - Bug at C32 - Whitespace is removed
  • CELLSNET-45996 - Bug at A30 - Newlines are removed

We tested this issue with the following code. Please see the output Pdf and its screenshot for a reference. To highlight the issues further, we have also added the comments inside the output Pdf.

Download Link:
output-comments added.pdf (63.1 KB)

C#

Workbook wb = new Workbook("WrongDateTime.ods");

wb.Worksheets[1].IsVisible = false;
wb.Worksheets[2].IsVisible = false;

PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;

wb.Save("output.pdf", opts);

Screenshot:

sc.png (161.9 KB)

1 Like
5

@mservdev,

This is to inform you that we have fixed your issues (“CELLSNET-45995” and “CELLSNET-45996”) now. We will soon provide the fix after performing QA and including other enhancements and fixes.

6

@mservdev

Thanks for using Aspose APIs.

Please download and try the following fix for your issues (i.e. CELLSNET-45995, CELLSNET-45996) and let us know your feedback.

7

The issues you have found earlier (filed as CELLSNET-45996,CELLSNET-45995) have been fixed in Aspose.Cells for .NET 18.4. Please also check the document/article for your reference: Install Aspose Cells through NuGet|Documentation