We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Convert Excel to PDF on Negative Time custom format(h:mm)

  1. Convert .xlsx file with custom formatting not working when convert to PDF file.
    For convertion we used below code from aspose
    PdfSaveOptions saveOptions = new PdfSaveOptions();
    Workbook wb = new Workbook(@"C:\test.xlsx”);
    wb.Save(@"C:\test.pdf”, saveOptions);

  2. For ex we have data as “-0.0736111111111112” and we applied custom format “h:mm” and “enabled 1904 format” in excel template for display negative value
    image.png (9.4 KB)

  3. The below highlighted value format not exported to PDF
    EXCEL:
    image.png (3.6 KB)
    image.png (5.3 KB)

And shown as hash in PDF file
PDF:
image.png (1.4 KB)

@sanmscsesophista,
We are looking into this issue and will share our feedback soon.

@sanmscsesophista,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47102 – "#########" displayed after converting Excel to PDF on Negative Time custom format(h:mm)

@sanmscsesophista,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47102”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Thanks Amjad.
I am looking forward for the fixed version of aspose.

@sanmscsesophista,

You may expect the fixed version in the next few days (3-5 days or so).

Keep in touch.

@Amjad_Sahi,

Thanks for the information…

@sanmscsesophista,
Please try our latest version/fix: Aspose.Cells for .NET v20.1.1:
Aspose.Cells20.1.1 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells20.1.1 For .Net4.0.Zip (5.0 MB)

Your issue should be fixed in it.

Hi @ahsaniqbalsidiqui \ @Amjad_Sahi ,
I’ve tried the by replacing both Aspose.Cells.dll alternatively with my old dll.
The issue still not fixed. can you please check it again.

@sanmscsesophista

May be your project is still using older version. Please make sure that you are using the latest fix v20.1.1. You may print the version number in your program to confirm that you are using latest version/fix, see the line of code for your reference:
Console.WriteLine(CellsHelper.GetVersion());

We will also re-evaluate your scenario/case soon.

Hi @Amjad_Sahi

i’ve checked the version its v20.1.1. is there a way i can attach my excel sample which needs to convert as PDF. so this will be useful for you

@Venkat_IT,

Please zip the file and attach it here, we will check it soon.

Hi @Amjad_Sahi ,

Please refer the below sample excel which needs to be convert to PDF.
FYI,
i’m summarize the issue again
image.png (1.3 KB)
Enable “1904” option in excel
image.png (3.5 KB)

1)The value on column “A” needs to convert as custom format(“h:mm”) which works in Excel Perfectly.
2) But when convert to PDF it fails
PdfSaveOptions saveOptions = new PdfSaveOptions();
Workbook wb = new Workbook(@"C:\test.xlsx”);
wb.Save(@"C:\test.pdf”, saveOptions);

test.zip (5.8 KB)

@Venkat_IT,

Thanks for the template file and image files.

You are right, the issue is still there (as I tested) using your attached file with your code segment. The cell B2 still has the issue and is shown as “#########”. I have reopened the issue and we will be looking into your issue soon.

Hi @Amjad_Sahi ,
Ok. Please let me know once the issue fixed.
So that i could test and confirm you.

@Venkat_IT,

Sure, we will do. We will evaluate/figure out your issue in the next week hopefully.

@Venkat_IT,

Please try our latest version/fix: Aspose.Cells for .NET v20.1.5 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.1.5 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells20.1.5 For .Net4.0.Zip (5.0 MB)

@Amjad_Sahi,

Thanks, it worked finally. :slightly_smiling_face:

@Venkat_IT,

Good to know that you are up and running again. In the event of any further query or issue, feel free to write us back, we will be happy to assist you soon.

The issues you have found earlier (filed as CELLSNET-47102) have been fixed in Aspose.Cells for .NET v20.2. This message was posted using Bugs notification tool by Amjad_Sahi