Aspose.cloud.cells Axis Option Bounds and Change the Print Size

Aspose.Cells Cloud Product Family
1

I am evaluating aspose-cells-cloud-node.

in aspose.cloud.cells
Is it possible to adjust the maximum and minimum values ​​of the Axis Option Bounds and change the print size to A4 or A3?

2

@yamauci112,

Currently, Cells Cloud Services supports changing the size of the worksheet page. But Axis Object operations are not supported. You can tell us the detailed requirements for the operation of the Axis object, and we will develop new APIs for your requirements.

We are enclosing codes for setting page size. Please refer to them.

describe('CellsCustomApi ', function () {

this.timeout(200000);

describe(‘cellsPageSetupPostPageSetup’, function () {

it('should call cellsPageSetupPostPageSetup successfully', function () {

  const cellsApi = BaseTest.initializeCellsApi();

  const filename = "Book1.xlsx";

  var data = fs.createReadStream(localPath + filename);

  var req = new model.UploadFileRequest();

  req.path = "Temp/" + filename;

  req.file = data;

  return cellsApi.uploadFile(req)

    .then((result) => {

      expect(result.body.uploaded.length).greaterThan(0);

      var req = new model.CellsPageSetup_PostPageSetupRequest();

      req.name = filename;

      req.sheetName = "Sheet1";

      req.pageSetup = new model.PageSetup();

      req.pageSetup.blackAndWhite = true;

      req.pageSetup.paperSize = "PaperA3";

      req.folder = "Temp";

      return cellsApi.cellsPageSetupPostPageSetup(req)

        .then((result) => {

          expect(result.body.code).to.equal(200);

          expect(result.response.statusCode).to.equal(200);

          var req = new model.CellsPageSetup_GetPageSetupRequest();

          req.name = filename;

          req.sheetName = "Sheet1";

          req.folder = "Temp";

          return cellsApi.cellsPageSetupGetPageSetup(req)

            .then((result) => {

              expect(result.body.code).to.equal(200);

              expect(result.response.statusCode).to.equal(200);

              expect(result.body.pageSetup.paperSize).to.equal("PaperA3");

            });

        });

    });

});

});

});

3

below we
Aspose.Cells for Node.js
This is the code when I evaluated

I would like to be able to edit the maximum and minimum values ​​of each axis in aspose-cloud-cells as well as Aspose.Cells

If you do api development, how long will it take to update?

”
let chart = sheet2.getCharts().get(0)

chart.getValueAxis().setMinValue(minl)

chart.getSecondValueAxis().setMinValue(minr)
”

4

@yamauci112,

We got your requirements. We will do a development plan for your requirements.

5

@yamauci112,

Aspose.Cells Cloud SDK 22.12 for NodeJS has been released. You could use new APIs to update the chart axis.
Please refer to the following documents:
Update Chart Second Value Axis|Documentation (aspose.cloud)
Update Chart Value Axis|Documentation (aspose.cloud)
Update Chart Category Axis|Documentation (aspose.cloud)
Charts|Aspose.Cells Cloud Document