FAQ

From Documentation




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:

You can see an example at Working with Spreadsheet/Use Case/User Permission.

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.

After exporting to a PDF file, the PDF shows unexpected fonts or has missing characters

There are many reasons, but we list the most possible ones:

  • You choose a wrong encoding for some characters.
For example, you apply "Calibri" on a Chinese character. You can resolve it by applying the correct font.
  • The computer of your PDF viewer software doesn't install corresponding fonts.
For ZSS doesn't embed fonts into a exported PDF file, your computer should install the corresponding fonts to display the file correctly. You can test it by opening the PDF file in another computer or different OS. Please check installed fonts on your computer. Installing missing fonts can solve this problem.

The ZSS bundled iText will find fonts from the following paths. Please check the fonts you apply are available in these paths: Won't scan its subdirectories

   c:/windows/fonts
   c:/winnt/fonts
   d:/windows/fonts
   d:/winnt/fonts
   /Library/Fonts
   /System/Library/Fonts

Will scan its subdirectories

   /usr/share/X11/fonts
   /usr/X/lib/X11/fonts
   /usr/openwin/lib/X11/fonts    
   /usr/share/fonts
   /usr/X11R6/lib/X11/fonts

Extracted from FontFactoryImp com.lowagie.text.FontFactoryImp.

  • The server to export a PDF doesn't install corresponding fonts.
It might happen when you export a PDF on a Linux server without Microsoft fonts installed. (Unbuntu should install the package ttf-mscorefonts-installer, "installer for Microsoft TrueType core fonts"). You will find the exported PDF's size is smaller than the one exported correctly. Install the corresponding fonts can solve this issue.


How do I know my file can be loaded correctly with ZSS

In general, those functions we implement with the toolbar are supported. However, the best way is to upload your files to the ZK Spreadsheet EE Demo App. It's a ready-to-use web application based on ZSS component. You just run the war with a Java application server, then you can upload files via the menu, File / Open / Upload.



All source code listed in this book is at Github.


Last Update : 2015/08/25

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