SpreadJS Designer - Decimal round didn't work on column

SpreadJS Designer - Decimal round didn't work on column

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

• 

  mentezami

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 May 2021, 7:28 am EST - Updated 3 October 2022, 12:45 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.

  

  1320×953 154 KB

  

  1241×952 145 KB

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 24 May 2021, 11:27 pm EST - Updated 3 October 2022, 12:45 am 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

  

• 

  kwallace

  • Post Options:
  • Link
    Copy

  Posted 25 May 2021, 4:35 am EST - Updated 3 October 2022, 12:45 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
  
  

  

  968×622 26.6 KB

  

  962×605 20.4 KB

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  aschrom

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 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