StatusBar count/min/max Fns throw null after update from 13.0.7 to 13.1.x

StatusBar count/min/max Fns throw null after update from 13.0.7 to 13.1.x

Posted by: davide.vago on 8 June 2020, 4:28 am EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 June 2020, 4:28 am EST - Updated 3 October 2022, 1:16 am EST

  Dear sirs,

  I’m writing in regards of an issue that I’m not able to figure out and replicate outside the project I’m currently working on.

  Basically, after installing version 13.1.x I’m not able to see the stats near the zoom slider within the statusBar component. It appears that the statusBar renders normally and the values get updated whenever the user draw a selection within the workBook instance (Please see the attached animated gif for reference) but the value for each stat is always null.

  

  I’ve tried to replicate the issue within a sandbox but it does work as expected so I then tried to update and revert every single dependency of the project to understand if some package was creating some internal conflict but it does seems like something changed on the statusBar between 13.0.7 and 13.1.0 that silently killed the functionality.

  I’m sharing with you the current implementation we use (https://codesandbox.io/s/spreadjs-workbook-import-statusbar-ph8tu?file=/src/components/WorkBookInstance.vue) for the workbook instance, however the sandbox does work as expected so there is nothing really you could see.

  I was wondering if your developers will be able to understand what could have caused some issues with the StatusBar diffing the code with the previous version 13.0.7.

  Looking forward to hearing from you.

  p.s. it would be good to see in the next releases the configuration of min/max zoom ranges to permit us to remove the hack suggested a few months ago to limit the min/max slider

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2020, 3:15 pm EST

  Hi,

  We have asked the dev team for their input on this issue and will let you know once we get an update from the team.

  Regarding limiting the zoom level, we have asked the dev team for update and will let you know as soon we get the update.

  Regards
  
  Sharad

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 15 June 2020, 5:07 pm EST

  Hi Davide,

  Dev team reviewed the sample and gif. Devs have informed us that it seems like intended behavior and the value should be null in version 13.0.7 too.
  
  Further, they have asked for a video of the actual issue in your application and not just the elements snapshot. Please provide the same so that we could further investigate the issue.

  Regards

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 16 June 2020, 2:40 am EST - Updated 3 October 2022, 1:16 am EST

  Sure, not a problem:

  Please find in attachment the video of our UI using v.13.0.7
  
  

  Here the console:
  
  

  https://gccontent.blob.core.windows.net/forum-uploads/file-391730d1-6e5e-4038-96b1-d5c7f3f571db.gif(image larger than 4 MB)

  From version 13.1.0 onward the status bar doesn’t show anything but the zoom slider (let me know if you need the screen record also for that one but I guess they will understand)

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 16 June 2020, 9:09 pm EST

  Thank you for the additional information. I’ve shared(SJS-4517) it with the dev team and will let update you after I get the update from the team.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 1 July 2020, 3:50 pm EST

  We are sorry but devs are also unable to reproduce the issue and just from looking at the provided gifs, there is not enough information to comment on the issue.
  
  Could you please share a sample that replicates the issue so that we could further investigate it, if your code/resources are private and you couldn’t share it on the public forum then you may also create a ticket on our private support portal, https://supportone.componentone.com/ and share the sample.

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 19 July 2020, 7:22 pm EST

  Hi Sharad,

  After 2 weeks of investigation we figured out what was going wrong in our build.
  
  Our build uses a subset of available formulas on the CalcEngine which worked till v. 13.0.7 then suddenly stopped on v. 13.1.x, apparently the fix from our side has been to add ```
  
  _SUBTOTALFORSTATUSBAR

  
  It seems a bit odd having to add a formula starting with _ (which I suppose is for internal use only) but at least solved our issue.
  
  Thanks for the support.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 20 July 2020, 4:34 pm EST

  Hi Davide,

  Thank you for informing us that your issue has been and the solution that worked for you. yes, you are right, formulas starting with _ are for internal use only so we suggest not removing any of those formulas.

  Regards