The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.After installing sheetnode it is possible for users to enter data into cells whilst in the view mode. This is a little confusing as entering data will not be saved if it is in the view mode (rather than edit)
Comments
Comment #1
infojunkieThat's correct and by design. I don't intend to change that behaviour, but maybe a little warning message would be appropriate in view mode.
Comment #2
bobinabottle commentedI would like to disable editing when in the view mode if possible.. are there any config options I can look into? or would it require massive code overhaul? Any chance someone could point me in the right direction? Thanks.
Comment #3
infojunkieComment #4
westbywest commentedDoes the SocialCalc javascript app that is embedded in the sheetnode module itself support a "read-only" parameter? It would be pretty trivial to pass such parameter when invoking SocialCalc based on whether you are displaying a sheetnode in view or edit mode.
Comment #5
infojunkieNo, it doesn't as far as I could find.
Comment #6
westbywest commentedHi,
I appreciate your response. My own research into the bowels of SocialCalc also seems to conclude there is no well-defined way to turn off cell edits in "view mode."
As a work-around, I've defined a custom node-sheetnode.tpl.php in my theme, warning the user that edits made to the spreadsheet will not be saved.
Comment #7
hlan commentedHi Westbywest,
Is there any chance to share that code 'cos I don't really know how to get that message.
Thanks
Hlan
Comment #8
infojunkieThe latest version of Sheetnode allows to select one of 3 modes for viewing the spreadsheet: Read-only mode, HTML table mode, and "fiddle" mode (which allows to enter data but not save). The active mode can be selected by visiting Admin > Site configuration > Sheetnode settings.