Forums Home / Spread / SpreadJS
Posted by: Jean.s on 27 February 2024, 3:49 am EST
Jean.s
Posted 27 February 2024, 3:49 am EST
HI,
Would it be possible to represent another sheet of the same workbook inside a “Floating Object”?
I think it would be a very interesting feature for building very sophisticated dashboards with different zones that can, for example, expose data in separately scrollable tables and viewports.
This would be a functionality similar to the “Camera” but with “active” behaviors.
Thank you
ankit.kumar
Posted 27 February 2024, 7:34 pm EST
Hi,
I couldn’t understand what do you mean by " similar to the “Camera” but with “active” behaviors.". Could you kindly elaborate?
Yes, you could add another workbook into a floating object. You could refer to the following demo on Floating Object: https://developer.mescius.com/spreadjs/demos/features/floating-object/basic-floating-object/angular
In case of workbook inside floating object, you will need to handle various cases, like when the Sheet is changed, you need to create the workbook instance again because on sheet change, floating object is removed (by design). Similar, you need to call the repaint() method whenever the floating object is resized and for similar cases. Also, if you show a particular sheet in the floating object, you need to handle all the changes by yourself like Value Changes.
If you want to show the contents of other sheet, you could just pass the reference of other sheets in the Camera Shape.
However, if it doesn’t satisfy your requirement, kindly do elaborate your requirement so that we could have a better understanding of your requirement and we could assist accordingly.
Regards,
Ankit
Jean.s
Posted 27 February 2024, 9:23 pm EST - Updated 28 February 2024, 2:18 am EST
Hi Ankit, thank you for your answer.
My idea is to have a functionality that let me expose a sheet (of the same workbook) inside a kind of floating object. A “Camera Shape” do that but i can’t interact with it. I cannot edit value, scroll viewport etc.
The example that you linked is very similar but i’m thinking to a native functionality do do that with a single sheet of the same workbook.
I hope to have been clear.
Thanks
G.
ankit.kumar
Posted 28 February 2024, 10:15 pm EST
Hi,
Currently, the requested feature is not supported and also not implemented in other SpreadSheets like Google Sheets, Microsoft Excel. Similar to the sample I shared with you earlier, you could extend the sample and achieve the requirement.
Also, I have escalated it to the concerned dev team as an enhancement request. The internal tracking id for the same is: SJS-23040. I will let you know when I have more info on this from the dev team.
Regards,
Ankit
ankit.kumar
Posted 16 April 2024, 11:09 pm EST
Hi,
The devs have examined your use case and they have mentioned that the use case belongs to the “Canvas Layout”, and not the floating object case.
To support the “Canvas Layout” is in our product backlog with tracking id: SJS-16723. Currently, there is no ETA for the feature.
I will let you know when there is further info on this from the dev team or when the feature will be available.
Regards,
Ankit
Jean.s
Posted 16 April 2024, 11:46 pm EST
Hi Ankit,
thank you for your update.
It would be useful to better understand wath do you mean with “Canvas Layout”.
regard
ankit.kumar
Posted 17 April 2024, 5:50 pm EST
Hi,
By “Canvas Layout”, I mean that instead of SpreadJS inside the floating object (like the previously provided sample), it should be drawn on the Canvas; like how the charts are drawn on the SpreadJS.
Regards,
Ankit
