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

Free Support Forum - aspose.cloud

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

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?

@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");

            });

        });

    });

});

});

});

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)

@yamauci112,

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