Where did the isAutoFit option go in v4.0?

Aspose.Cells Cloud Product Family
1

In the aspose.cells cloud v3.0 Convert endpoint: /cells/{name}

There is a wonderful feature called isAutoFit.

It seems in v4.0 there is no longer an isAutoFit option.

When I include isAutoFit on a v4.0 call, it’s ignored.

Is the isAutoFit option/feature being removed in v4.0?

I, for one, certainly hope that is not the case, it’s a wonderful feature and one that we rely on heavily.

Any advice?

3

@thomp361 Hello, we will consider adding this feature in the next version, v4.0. My question is, do you only need to add this feature to the /cells/{name} endpoint, or is it required for all convert, export, and saveas statements?

4

@xuejianzhang Thank you, isAutoFit is really a great feature, takes all the guess work out when converting to Excel to PDF, everything just fits when this feature is set to true.

We use:

GET /cells/{name}

API reference here.

5

@thomp361 ,
Thank you for the feedback. This feature will be added to the Cells Cloud 4.0 Format Conversion APIs in the next release.

6

@thomp361 ,
The Cells Cloud 4.0 Format Conversion APIs now support query extension parameters, including AutoColumnsFit, AutoRowsFit, and more. Please refer to the code example in the SDK .NET library below for implementation details.

        CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("ProductClientId"), Environment.GetEnvironmentVariable("ProductClientSecret"));
        ConvertSpreadsheetRequest convertSpreadsheetRequest = new ConvertSpreadsheetRequest();
        convertSpreadsheetRequest.Spreadsheet = "EmployeeSalesSummary.xlsx";
        convertSpreadsheetRequest.format = "pdf";
        convertSpreadsheetRequest.AddExtendQueryParameter("AutoColumnsFit", "true");
        using (Stream stream = cellsApi.ConvertSpreadsheet(convertSpreadsheetRequest))
        {
            using (FileStream fileStream = File.Create(@"C:\EmployeeSalesSummary_AutoColumnsFit.pdf"))
            {
                fileStream.Position = 0;
                stream.CopyTo(fileStream);
                fileStream.Close();
            }
        }