SpreadJS Designer - Decimal round didn't work on column

Posted by: mentezami on 24 May 2021, 7:28 am EST

  • Posted 24 May 2021, 7:28 am EST

    Hi,
    Decimal round didn't work when:
    1. selecting more than 1 cell with an empty cell on top of the selected area
    2. if we select a column.

    Can you please let us know if it can be fixed? and do you have any ETA, please?

    Thanks.

  • Replied 24 May 2021, 11:27 pm EST

    Hi,

    This is expected behavior from SpreadJS. The SpreadJS follows the Excel policy for the Decimal round feature excel also does not allow this feature for the given scenario. Please refer to the following gif of the Excel and let us know f you face any issues.

    Regards
    Avinash

  • Replied 25 May 2021, 4:35 am EST

    Hi,
    The behavior in SpreadJS is not matching that of Excel.
    If I select a column and choose 'Accounting' in the Number Format dropdown, then clicking on the 'Increase Decimal' or 'Decrease Decimal' buttons respond accordingly where the type changes to Custom and the decimal amounts increase or decrease. However doing this in SpreadJS, clicking the Increase or Decrease decimal buttons on the selected column with type changed to 'Accounting' causes no response.
    Would this be able to be fixed?

    Thanks,
    Keith
  • Replied 25 May 2021, 5:41 pm EST

    Hi,

    Thanks for the information. We are able the observe the issue at our end hence we have escalated this issue to the concerned team for further investigation. We will update you regarding this as we get any information from the team. The internal ID for this issue will be SJS-8839.

    Regards,
    Avinash
  • Replied 14 June 2021, 12:21 pm EST

    Further to Keith's comment, when the entire column is formatted as a number in Excel, you can select the entire column, or empty cells above the cells desired to be rounded, and the round function will still work. However, in SpreadJS, if I format the entire column as number, and try to then round the whole column or a selection of cells with an empty cell on top, round does not work.
  • Replied 14 June 2021, 6:06 pm EST

    Hi,

    The Devs are currently looking into it and it will be fixed in our next biweekly release that is v14.1.1. We will update here once the build gets officially released.

    Regards
    Avinash
  • Marked as Answer

    Replied 28 June 2021, 7:48 pm EST

    Hi,

    The 14.1.1 has been released. Please update the latest build and let us know if the issue still persists for you.

    v14.1.1: http://cdn.grapecity.com/spreadjs/14.1.1/Files/SpreadJS.Release.14.1.1.zip

    Regards,
    Avinash
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels