Forums Home / Spread / SpreadJS
Posted by: mathieu.bilodeau-roy on 18 August 2021, 12:47 pm EST
mathieu.bilodeau-roy
Posted 18 August 2021, 12:47 pm EST
Hi,
We’ve been using the Designer and we like the formula bar panel and it’s “named-range-selector” box. Unfortunately, it looks like the box only shows the active selection as a single Cell.
Like in Excel, we would like for it to resolve ranges as possible Named Ranges.
i.e.: If I create a named range “MyRange” which is located at A1, I would like the box to show MyRange instead of A1.
Is it possible to configure?
Thanks,
Mathieu
mathieu.bilodeau-roy
Posted 18 August 2021, 1:20 pm EST
From what I am seeing in the minified code, I could fix this problem by overriding the updateNameRangeSelectorValue method.
Unfortunately, I am not sure which object it is a part of so I can override its prototype
avinash.pathak
Posted 19 August 2021, 5:46 am EST
Hi,
We are sorry but currently, this feature is not supported but it is already in our backlog and it will be available in our next stable release. We will update here once the feature will be released officially. The internal ID for this will be SJS-9467.
Regards,
Avinash
mathieu.bilodeau-roy
Posted 19 August 2021, 7:44 am EST
Thank you for the quick reply.
Are you able to guide me to your release schedule and roadmap, if it is public information?
I am interested to know when this stable release will happen and what will be a part of it.
Thanks
Mathieu
avinash.pathak
Posted 20 August 2021, 2:41 am EST
Hi Mathieu,
We have escalated this issue to the PM and asked them regarding the same. We will update you once we get any information.
Regards,
Avinash
avinash.pathak
Posted 7 September 2021, 6:17 am EST
HI,
The Devs informed us that. The only roadmap we have at the moment is here: https://www.grapecity.com/blogs/spread-js-2021-roadmap I would say the release time is also different, v14.2 is planned for September, not July like that blog mentions.
Also, password protecting worksheets will not be in there, but things like Angular 12 and Vue 3 support will be in there, among a lot of designer enhancements including the one for this case.
Regards,
Avinash
avinash.pathak
Posted 23 September 2021, 7:25 am EST
Hi,
The issue has been fixed in our latest 14.2.0 build. Please update to the latest build and let us know if you still face any issues.
Regards,
Avinash
mathieu.bilodeau-roy
Posted 30 September 2021, 10:30 am EST - Updated 3 October 2022, 9:36 am EST
Hi Avinash,
Thank you for the update.
It’s working really well.
The only issue I have is a visual glitch that you can see in the attachment.
I am still investigating to see if it’s a CSS error on our end or not.
The feature works as expected for everything else, thank you!
EDIT: I have a quick question for you : Is there anyway to make a read-only mode of the formula bar and the range drop down? We’d like under certain circumstances allow the user to see the ranges and navigate to them, but not create new one.
avinash.pathak
Posted 1 October 2021, 7:34 am EST
Hi,
Regarding readOnly mode for formula bar.
You may lock the cells on which you need read-only mode. Please refer to the following docs and let me know if you face any issues.
lock cells: https://www.grapecity.com/spreadjs/docs/v14/online/celllock.html
protection demo: https://www.grapecity.com/spreadjs/demos/features/worksheet/protection#demo_source_name
Regarding disabling the nameManger command dynamically:
Please refer to the following sample and let me know if you face any issues.
sample: https://codesandbox.io/s/spread-js-starter-forked-kzeos?file=/src/index.js/
Regards
Avinash
