FAQ"

From Documentation
(How do I save the content of ZSS or even save it to a database?)
Line 4: Line 4:
  
  
* Does ZSS support user permission control?
+
* '''Does ZSS support user permission control?'''
*: No. User permission feature involves authentication and authorization which is out of ZSS function's scope. Since ZSS cannot identify a user, it cannot assign a user with corresponding permissions. But you can easily integrate existing framework like Spring Security and implement your user permission features with ZSS. Please refer to the following sections:
+
: No. User permission feature involves authentication and authorization which is out of ZSS function's scope. Since ZSS cannot identify a user, it cannot assign a user with corresponding permissions. But you can easily integrate existing framework like Spring Security and implement your user permission features with ZSS. Please refer to the following sections:
** Hide the toolbar and the context menu to prevent editing. Please refer to [[ZK Spreadsheet Essentials/Working with Spreadsheet/Control Components]].  
+
:* Hide the toolbar and the context menu to prevent editing. Please refer to [[ZK Spreadsheet Essentials/Working with Spreadsheet/Control Components]].  
** Disable available functions for different users. Please refer to [[ZK Spreadsheet Essentials/Working with Spreadsheet/Advanced/Disable Functions]].
+
:* Disable available functions for different users. Please refer to [[ZK Spreadsheet Essentials/Working with Spreadsheet/Advanced/Disable Functions]].
** Protect sheets and set available actions. Refer to <javadoc directory='zss' method='protectSheet(java.lang.String , boolean , boolean , boolean , boolean , boolean , boolean , boolean , boolean , boolean , boolean , boolean allowSorting, boolean , boolean , boolean , boolean )'>org.zkoss.zss.api.Range</javadoc>
+
:* Protect sheets and set available actions. Refer to <javadoc directory='zss' method='protectSheet(java.lang.String , boolean , boolean , boolean , boolean , boolean , boolean , boolean , boolean , boolean , boolean , boolean allowSorting, boolean , boolean , boolean , boolean )'>org.zkoss.zss.api.Range</javadoc>
 
 
  
 +
* '''How do I save the content of ZSS or even save it to a database?'''
 +
*: To save the content of ZSS, we recommend to export it as an Excel file instead of saving it rows by rows. It is also the way we implement the "Save" function in zssapp.  After exporting, you can save the file into a BLOB type column of a database.
 +
:* How to export: [[ZK_Spreadsheet_Essentials/Working_with_Spreadsheet/Handling_Data_Model/Export_to_Excel | Export to Excel]]
 +
:* Integrate custom saving process to ZSS toolbar's Save button: [[ZK_Spreadsheet_Essentials/Working_with_Spreadsheet/Advanced/Toolbar_Customization#Save_Book| Toolbar Customization]]
  
  
 
{{ZKSpreadsheetEssentialsPageFooter}}
 
{{ZKSpreadsheetEssentialsPageFooter}}

Revision as of 06:00, 26 May 2015




  • Does ZSS support user permission control?
No. User permission feature involves authentication and authorization which is out of ZSS function's scope. Since ZSS cannot identify a user, it cannot assign a user with corresponding permissions. But you can easily integrate existing framework like Spring Security and implement your user permission features with ZSS. Please refer to the following sections:
  • How do I save the content of ZSS or even save it to a database?
    To save the content of ZSS, we recommend to export it as an Excel file instead of saving it rows by rows. It is also the way we implement the "Save" function in zssapp. After exporting, you can save the file into a BLOB type column of a database.


All source code listed in this book is at Github.


Last Update : 2015/05/26

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.