Export - CSV (All fields)
Export - CSV (Current fields)
ZSS-1417
edit cells referenced by OFFSET doesn't update the formula result
many text cells with right alignment consume much client rendering time
open a number filter causes a null pointer exception
color filter causes null pointer exception
zss throws a javascript error when quickly switching sheets
an overflowed text is not center-aligned correctly
clicking a cell causes a dragging selection
Slow performance when using XMLBean.getXxxList()
zss warning dialog header change from "warn" to "warning"
broken styles below merged cells after scrolling vertically
Impossible to use spreadsheet component from another classloader
when moving a chart in zssapp, it throws an IllegalStateException
copy the whole row doesn't copy the row height
When sheet protected and not allowed to insert link; the inserted LINK should be a String
Conditional formatting work incorrectly when using a formula
deleting a row causes ArrayIndexOutOfBoundsException
Problem with input into cell in ZK Spreadsheet in Microsoft Edge browser (Windows 10)
The filter type should follow the Excel spec.
right clicking doesn't open a custom context menu
Forget to copy over the new attibute in EditableFont
StringIndexOutOfBoundsException if click a hyperlink with empty address
Creating a sheet with a book range causes NullPointerException
a text is cut in a merged cell
the percentage format doesn't work after editing a number
a formula becomes a text after being edited
import bottom alignement incorrectly
IE8 change sheet report error. official demo also can be found this bug!
Should remove unnecessary ___ (three underscores) style class
a conditional formatting rule's "show icon only" is checked after exporting
Space gone in Vertical rotated text (rotate == 255)
IE9 only. Lift the IE9 StyleSheet upper limit (4095 selectors per style sheet)
IE9 only. Row height is unresonable large
IE9 only. Underscore("_") not seen when bottom vertical alignment
Delete button does not work on sheet with protected cells
IE9 only. ScrollPanel position sometimes wrongly reset to 0,0.
IE9 do not render 1st sheet of a workbook after navigation to another sheet.
Smart input cannot turn 1-Jan into a date format
alignment bugs when composite frozen and merged cells
Border missing when overlap merged cell
IE only. +90/-90 degree text not showing correctly.
Unexpected bottom border line in Table
JavaScript NPE
UiException: Illegal request when change sheet
Cannot disable moving a sheet left and right
PageUp does not stop editing
Create new book causes js error
Many Classes do not implement the Serializable Interface and in Cluster mode Fails
ClassNotFoundException when loading zssjsf
option (Select All) in autofilter dialog is not correctly shown
invalidate() make sheet scroll back to top.
{"searchers":{"groups":[{"searchers":[{"name":"Project","id":"project","key":"issue.field.project","isShown":true,"lastViewed":1750445319845,"shown":true},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true,"shown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1750445319849,"shown":true},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1750445319852,"shown":true},{"name":"Priority","id":"priority","key":"issue.field.priority","isShown":true,"shown":true},{"name":"Resolution","id":"resolution","key":"issue.field.resolution","isShown":true,"shown":true},{"name":"Creator","id":"creator","key":"issue.field.creator","isShown":true,"shown":true},{"name":"Affects Version","id":"version","key":"issue.field.affectsversions","isShown":true,"shown":true},{"name":"Fix Version","id":"fixfor","key":"issue.field.fixversions","isShown":true,"shown":true},{"name":"Component","id":"component","key":"issue.field.components","isShown":true,"shown":true},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true,"shown":true},{"name":"Link types","id":"issue_link_type","key":"issue.field.issuelinks","isShown":true,"shown":true},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true,"shown":true},{"name":"Description","id":"description","key":"issue.field.description","isShown":true,"shown":true},{"name":"Comment","id":"comment","key":"issue.field.comment","isShown":true,"shown":true},{"name":"Label","id":"labels","key":"issue.field.labels","isShown":true,"shown":true},{"name":"Query","id":"text","key":"text","isShown":true,"shown":true},{"name":" Freshservice Tickets","id":"customfield_10200","key":"com.atlassian.jira.plugin.system.customfieldtypes:textarea","isShown":false,"shown":false},{"name":"Development","id":"customfield_10800","key":"com.atlassian.jira.plugins.jira-development-integration-plugin:devsummary","isShown":true,"shown":true},{"name":"Hit Rate Index","id":"customfield_10000","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false,"shown":false},{"name":"Original story points","id":"customfield_11103","key":"com.atlassian.jpo:jpo-custom-field-original-story-points","isShown":true,"shown":true},{"name":"Parent Link","id":"customfield_11100","key":"com.atlassian.jpo:jpo-custom-field-parent","isShown":false,"shown":false},{"name":"Release Version History","id":"customfield_10310","key":"com.pyxis.greenhopper.jira:greenhopper-releasedmultiversionhistory","isShown":true,"shown":true},{"name":"Safety specification requirements","id":"customfield_11300","key":"com.atlassian.jira.plugin.system.customfieldtypes:radiobuttons","isShown":false,"shown":false},{"name":"Team","id":"customfield_11200","key":"com.atlassian.teams:rm-teams-custom-field-team","isShown":true,"shown":true},{"name":"Epic Colour","id":"customfield_10308","key":"com.pyxis.greenhopper.jira:gh-epic-color","isShown":false,"shown":false},{"name":"Epic Name","id":"customfield_10306","key":"com.pyxis.greenhopper.jira:gh-epic-label","isShown":true,"shown":true},{"name":"Epic Link","id":"customfield_10305","key":"com.pyxis.greenhopper.jira:gh-epic-link","isShown":true,"shown":true},{"name":"Epic Status","id":"customfield_10307","key":"com.pyxis.greenhopper.jira:gh-epic-status","isShown":false,"shown":false},{"name":"Business Value","id":"customfield_10303","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false,"shown":false},{"name":"Flagged","id":"customfield_10300","key":"com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes","isShown":true,"shown":true},{"name":"Epic/Theme","id":"customfield_10301","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true,"shown":true},{"name":"Story Points","id":"customfield_10302","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":true,"shown":true},{"name":"Rank","id":"customfield_10309","key":"com.pyxis.greenhopper.jira:gh-lexo-rank","isShown":true,"shown":true},{"name":"Sprint","id":"customfield_10304","key":"com.pyxis.greenhopper.jira:gh-sprint","isShown":true,"shown":true},{"name":"issueFunction","id":"customfield_10600","key":"com.onresolve.jira.groovy.groovyrunner:jqlFunctionsCustomFieldType","isShown":true,"shown":true}],"type":"DETAILS","title":"Details"},{"searchers":[{"name":"Created Date","id":"created","key":"issue.field.created","isShown":true,"shown":true},{"name":"Updated Date","id":"updated","key":"issue.field.updated","isShown":true,"shown":true},{"name":"Resolution Date","id":"resolutiondate","key":"issue.field.resolution.date","isShown":true,"shown":true},{"name":"Target end","id":"customfield_11102","key":"com.atlassian.jpo:jpo-custom-field-baseline-end","isShown":true,"shown":true},{"name":"Target start","id":"customfield_11101","key":"com.atlassian.jpo:jpo-custom-field-baseline-start","isShown":true,"shown":true}],"type":"DATES","title":"Dates"},{"searchers":[{"name":"Assignee","id":"assignee","key":"issue.field.assignee","isShown":true,"lastViewed":1750445319853,"shown":true},{"name":"Reporter","id":"reporter","key":"issue.field.reporter","isShown":true,"shown":true}],"type":"PEOPLE","title":"People"}]},"values":{"issuetype":{"name":"Type","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldtype\">Type:</label><span id=\"fieldtype\" class=\"fieldValue\">\n \n\n Bug \n </span></div>\n\n","editHtml":"\n\n\n\n <div class=\"field-group aui-field-issuetype\" >\n <label for=\"searcher-type\">Type</label> <select class=\"select js-default-checkboxmultiselect\"\n id=\"searcher-type\"\n multiple=\"multiple\"\n name=\"type\"\n data-max-inline-results-displayed=\"100\"\n data-placeholder-text=\"Find Issue Types...\">\n <optgroup>\n \n <option class=\" \"\n id=\"type_-2\"\n title=\"All Standard Issue Types\"\n value=\"-2\">All Standard Issue Types</option>\n \n <option class=\" \"\n id=\"type_-3\"\n title=\"All Sub-Task Issue Types\"\n value=\"-3\">All Sub-Task Issue Types</option>\n </optgroup>\n\n <optgroup label=\"Standard Issue Types\">\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12403&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_1\"\n selected=\"selected\" title=\"Bug\"\n value=\"1\">Bug</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12407&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10002\"\n title=\"Epic\"\n value=\"10002\">Epic</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12411&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_2\"\n title=\"New Feature\"\n value=\"2\">New Feature</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12415&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10003\"\n title=\"Story\"\n value=\"10003\">Story</option>\n </optgroup>\n\n <optgroup label=\"Sub-Task Issue Types\">\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12416&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10200\"\n title=\"Documentation\"\n value=\"10200\">Documentation</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12416&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10001\"\n title=\"Research\"\n value=\"10001\">Research</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12407&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10100\"\n title=\"Testing\"\n value=\"10100\">Testing</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12418&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10000\"\n title=\"Verify\"\n value=\"10000\">Verify</option>\n </optgroup>\n </select>\n </div>\n ","jql":"issuetype = Bug","validSearcher":true,"isShown":true},"project":{"name":"Project","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldpid\">Project:</label><span id=\"fieldpid\" class=\"fieldValue\">\n \n <a data-pid=\"10101\" data-issue-type-ids=\"1,\" href=\"/browse/ZSS\" title=\"Browse ZK Spreadsheet project\">ZK Spreadsheet</a> </span></div>\n","editHtml":" \n <div class=\"field-group aui-field-project\" >\n <label for=\"searcher-pid\">Project</label> <select class=\"js-project-checkboxmultiselect\"\n data-placeholder-text=\"Find Projects...\"\n id=\"searcher-pid\"\n multiple=\"multiple\"\n name=\"pid\">\n <optgroup label=\"Recent Projects\">\n </optgroup>\n <optgroup label=\"All Projects\" >\n <option data-icon=\"/secure/projectavatar?pid=10101&size=small\"\n selected=\"selected\" title=\"ZK Spreadsheet\"\n value=\"10101\">\n ZK Spreadsheet (ZSS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10600&size=small\"\n title=\"Freshdesk Jira Test Project\"\n value=\"10600\">\n Freshdesk Jira Test Project (FD)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=11100&size=small\"\n title=\"Keikai\"\n value=\"11100\">\n Keikai (KEIKAI)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=11200&size=small\"\n title=\"Keikai Doc\"\n value=\"11200\">\n Keikai Doc (KKDOC)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10800&size=small\"\n title=\"Project Q\"\n value=\"10800\">\n Project Q (PQ)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10400&size=small\"\n title=\"ZATS\"\n value=\"10400\">\n ZATS (ZATS)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10000&size=small\"\n title=\"ZK\"\n value=\"10000\">\n ZK (ZK)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10900&size=small\"\n title=\"ZK Addon\"\n value=\"10900\">\n ZK Addon (ZKADDON)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10201&size=small\"\n title=\"ZK Calendar\"\n value=\"10201\">\n ZK Calendar (ZKCAL)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10500&size=small\"\n title=\"ZK Charts\"\n value=\"10500\">\n ZK Charts (ZKCHARTS)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10700&size=small\"\n title=\"ZK CKeditor\"\n value=\"10700\">\n ZK CKeditor (ZKCK)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10300&size=small\"\n title=\"ZK Document\"\n value=\"10300\">\n ZK Document (ZKDOC)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=11000&size=small\"\n title=\"ZK Fiddle\"\n value=\"11000\">\n ZK Fiddle (ZKFIDDLE)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10701&size=small\"\n title=\"ZK Gmaps\"\n value=\"10701\">\n ZK Gmaps (ZKGMAPS)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10103&size=small\"\n title=\"ZK JSP\"\n value=\"10103\">\n ZK JSP (ZKJSP)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10203&size=small\"\n title=\"ZK Pivottable\"\n value=\"10203\">\n ZK Pivottable (ZKPVT)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10202&size=small\"\n title=\"ZK Spring\"\n value=\"10202\">\n ZK Spring (ZKSPRING)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10200&size=small\"\n title=\"ZK Studio\"\n value=\"10200\">\n ZK Studio (ZKSTUDIO)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10100&size=small\"\n title=\"ZTL\"\n value=\"10100\">\n ZTL (ZTL)\n </option>\n </optgroup>\n </select>\n </div>\n \n\n","jql":"project = \"10101\"","validSearcher":true,"isShown":true},"assignee":{"name":"Assignee","editHtml":"\n \n <div class=\"field-group aui-field-userlist\" >\n <label for=\"searcher-assigneeSelect\">Assignee</label> <fieldset rel=\"assignee\" class=\"hidden user-group-searcher-params\">\n </fieldset>\n <select class=\"js-usergroup-checkboxmultiselect\" multiple=\"multiple\" id=\"assignee\" name=\"assignee\" data-placeholder-text=\"Enter username or group\">\n <optgroup>\n <option class=\"headerOption\" data-icon=\"https://tracker.zkoss.org/secure/useravatar?size=xsmall&avatarId=10123\" value=\"empty\" title=\"Unassigned\">Unassigned</option>\n </optgroup>\n <optgroup>\n </optgroup>\n </select>\n <input type=\"hidden\" name=\"check_prev_assignee\" value=\"true\">\n </div>\n \n","validSearcher":true,"isShown":true},"status":{"name":"Status","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldstatus\">Status:</label><span id=\"fieldstatus\" class=\"fieldValue\">\n \n Closed </span></div>\n","editHtml":"\n <div class=\"field-group aui-field-constants\" >\n <label for=\"searcher-status\">Status</label> <select class=\"select js-default-checkboxmultiselectstatuslozenge\"\n data-placeholder-text=\"Find Statuses...\"\n id=\"searcher-status\"\n multiple=\"multiple\"\n name=\"status\"\n data-max-inline-results-displayed=\"100\"\n data-footer-text=\"-96 more options. Continue typing to refine further.\" data-status-lozenge=\"true\">\n <optgroup >\n <option selected=\"selected\" class=\"imagebacked\" data-icon=\"/images/icons/statuses/closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"success"}}\">Closed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/open.png\" value=\"1\" title=\"Open\" data-simple-status=\"{"id":"1","name":"Open","description":"The issue is open and ready for the assignee to start work on it.","iconUrl":"/images/icons/statuses/open.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">Open</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/inprogress.png\" value=\"3\" title=\"In Progress\" data-simple-status=\"{"id":"3","name":"In Progress","description":"This issue is being actively worked on at the moment by the assignee.","iconUrl":"/images/icons/statuses/inprogress.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">In Progress</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/reopened.png\" value=\"4\" title=\"Reopened\" data-simple-status=\"{"id":"4","name":"Reopened","description":"This issue was once resolved, but the resolution was deemed incorrect. From here issues are either marked assigned or resolved.","iconUrl":"/images/icons/statuses/reopened.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">Reopened</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/resolved.png\" value=\"10000\" title=\"In Testing\" data-simple-status=\"{"id":"10000","name":"In Testing","description":"A resolution has been taken, and it is awaiting verification by tester. From here issues are either reopened, or are closed. ","iconUrl":"/images/icons/statuses/resolved.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">In Testing</option>\n </optgroup>\n</select>\n </div>\n \n","jql":"status = Closed","validSearcher":true,"isShown":true}}}
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]
0.3
0