Aspose.cloud Excel to pdf conversion issue

Aspose.Cells Cloud Product Family
1

HI,

I am again facing issue with converting excel to pdf.

Converted excel to pdf using api. CERTI1660640091.pdf (56.1 KB)

Converted excel to pdf using Open Excel Online for Free CERTI.pdf (51.6 KB)

You will see difference in both the pdf. We want output like generated from Open Excel Online for Free

We are facing this issue from last 12 August 2022. Before that it was working fine.

I am using CERTI.zip (21.5 KB) this excel to convert in pdf format.

2

@dev12scube,
We have found the cause of the problem and logged a ticket CELLSCLOUD-11868 in our issue tracking system for further investigation and resolution. We will notify you as soon as it is resolved.

By the way, did you update the font for excel file?

3

@wangtao,

Any update on above query ?

4

@dev12scube,
We have a solution, and it has been tested on QA Server. We plan to release Aspose Cells Cloud 22.8 this week. Please wait a day or two.

5

@wangtao,
Thanks for your support.

6

@dev12scube,
We have released Aspose Cells Cloud 22.8. Please try it.

7

@wangtao,

I have tested it. Issue is not resolved yet.
Please check generated pdf. CERTI (2).pdf (51.6 KB)

8

@dev12scube,
We have checked your provided Excel file.
Page setup set print area of the sheet on Your Excel file. So only convert a print area of the sheet when you convert excel to pdf.
image.png (42.4 KB)

9

@wangtao,

I am uploading same excel in your portal Open Excel Online for Free , I am getting expected output.

Before few days ago we are getting expected output using same excel using Aspose Cells Cloud. But from last week we are facing same issue.

Can you explain steps for excel to pdf conversion in detail ?

10

@dev12scube,
Convert Excel to pdf according to the effect of Excel printing.

11

@dev12scube,
I removed the print area’s value and converted it tothe pdf file (53.0 KB) .
Please check the file which meets your requirements.

12

@wangtao,

I also expecting print area’s output.

But issue is CERTI1660640091.pdf (56.1 KB) in this file. There is not padding in bottom. You can check next CERTI.pdf for identifing issue.

CERTI.pdf (51.6 KB) This is generated from your portal and also we were generating same output from aspose cell cloud library using php. This pdf file is our expected output.

13

@dev12scube,
Now, we can reproduce the issue. Please try set OnePagePerSheet of pdfsaveoption is true.

e.g. 1

$extended_parameters = array (
“OnePagePerSheet” => “true”
);
$result = $this->instance->postExport($files , ‘workbook’,‘pdf’,$extended_parameters );

e.g. 2

    $extended_parameters = array (
        "OnePagePerSheet" => "true"
    );
    $result = $this->instance->cellsWorkbookPutConvertWorkBook($path ,$format, $password,  $outPath,null,$extended_parameters);
14

@wangtao,

Its working for workbook but not for worksheet.

Below is my code :

$extended_parameters = array (
“OnePagePerSheet” => “true”
);

$result = $this->cells->postExport($files, ‘worksheet’,‘pdf’,$extended_parameters ); // Not working

$result = $this->cells->postExport($files, ‘workbook’,‘pdf’,$extended_parameters ); // Working

15

@dev12scube,

We found the issue and will fix it ASAP.

16

@dev12scube,
We have updated the fixed version(22.8.1) for Aspose Cells Cloud.
Please try it.

17

@wangtao,

I have checked, Its not working.

When I am using workbook its working. But for worksheet its not working.

18

@dev12scube,
Please check my exported file (51.5 KB).
.
Does it meet your requirement?

We are enclosing the test code.

$book1 = “CELLSCLOUD-11868.xlsx”;

    $files = array (

        $book1 =>  CellsApiTestBase::getfullfilename($book1)

    );

    $extended_parameters = array (

        "OnePagePerSheet" => "true"

    );

    $result = $this->instance->postExport($files , 'worksheet','pdf',$extended_parameters );

    // print( $result['files'][0]['file_content']);

    $this->assertNotNull($result);

   

    $bin = base64_decode($result['files'][0]['file_content'], true);

    file_put_contents('file.pdf', $bin);
19

@wangtao,

Not meeting. Can you please compare attached two pdfs below :

Your output TestCELLSCLOUD11870_CELLSCLOUD-11868_xlsx_worksheet_0.pdf (51.5 KB)

Our expected output is CERTI.pdf (51.6 KB)

20

@dev12scube,

We update parameters and export the new result.pdf (51.5 KB)
. Please check it.

Please refer to the new parameter code:

$extended_parameters = array (

        "OnePagePerSheet" => "false"

    );

    $result = $this->instance->postExport($files , 'worksheet','pdf','true',$extended_parameters );