Formulas to reference Sheets with spaces

Question

I'm trying to create a formula to reference a cell in another sheet, but that sheet name contains a space. The Excel style of reference 'Sheet 2'!A1 is not working, and the sheet name is replaced by a '1/' (tested in the demos site).

Is this possible, or in this case sheet names cannot have spaces in them?

Thank you

Sangeetha Priya Murugan · Accepted Answer

Hi ShareValue, 
 
Thank you for contacting Syncfusion support. 
 
We have checked your reported issue and we are not able to reproduce it in our end. And the cross sheet formula reference with the sheet name contains space is working properly in our end. For your convenience, we have prepared the sample with cross sheet formula in F column which contains space in it. Please find the link below. 
 
Sample Link: http://jsplayground.syncfusion.com/0vf2tey1 
 
Could you please check the above details and get back to us with more details, if you need any further assistance on this. 
 
Regards, 
Sangeetha M

ShareValue · Answer

Thank you for the answer. I've tested on our dev environment and it works correctly. Before we started using it, we tested on your demo site (used this one http://asp.syncfusion.com/demos/web/spreadsheet/contextmenu.aspx), created and sheet and tried to reference it, and it didn't work. Must be on an older version.

Thanks again for the help.

Sangeetha Priya Murugan · Answer

Hi ShareValue, 
 
Thank you for your update. 
 
We are happy to hear that your issue has been resolved and we would let you know that our demo site refers the older version only. Please get back to us, if you need any further assistance on this. 
 
Regards, 
Sangeetha M