dewmal / zkspreadsheet Goto Github PK

zssdemo/test/hyperlink.zul

Select A1:C9, move down one row.
A8: 123 -> A9: 0 because the original referenced C1 in formula does not 
change(should changed to C2)

Can move a specified range area.

Can show bullet list in cell.

Can un-hide hidden columns in the specified range.

Support drag sizing to hide column.

Can hide specified rows(Not necessary contiguous).

Can hide the specified columns(not necessary contiguous).

Support Range.setStyle()

When drag to select an area, the area boundary shall snap to the boundary of 
merged cells.

Support fillUp()

Support sort

Able to remove columns and do formula shift accordingly.

Support validation dropdown list

For hidden columns, shall not show.

Hello,
I have noticed that default locale is not respected after upgrade to beta2 
version. Was there any change in this behaviour?

I have even tried to set prefered locale in ZK using 
webApp.setAttribute(org.zkoss.web.Attributes.PREFERRED_LOCALE, ...); but with 
no result.

I am setting pattern in cell format (something like #,##0.000) and expect to 
see locale specific separators in application. It was working OK in previous 
version.

Thank you for any comment.

Can delete a range and move neighbor cells left or up.

Support Range.fillDown()

ZK Spreadsheet 1.x cannot show rich text in a cell. Need to support it.

ZK Spreadsheet 1.x support Excel 97-2003 only. Need to support Excel 2007
xlsx file.

ZK Spreadsheet 1.x will evaluate same cell several times in a formula
evaluation. It will waste computation time a lot. Shall cache and simply
the evaluation path and avoid unnecessary evaluation.

What steps will reproduce the problem?
1. install the zssapp.war under tomcat
2. call th zssapp in ie

What is the expected output? What do you see instead?
see attached file

What version of the product are you using?
zss-app-2.0.0-Beta2

Please provide any additional information below.
from tomcat log:
SCHWERWIEGEND: >>org.zkoss.zk.ui.UiException: Illegal request: wrong data, 
{"token":"0","sheetId":"24998777","type":"visible","direction":"","dpWidth":2173
,"dpHeight":3801,"viewWidth":0,"viewHeight":0,"blockLeft":0,"blockTop":0,"blockR
ight":10,"blockBottom":20,"fetchLeft":-1,"fetchTop":-1,"fetchWidth":-1,"fetchHei
ght":-1,"rangeLeft":0,"rangeTop":0}, for 
org.zkoss.zss.ui.au.in.CellFetchCommandHelper@4b35d5
>>  at 
org.zkoss.zss.ui.au.in.CellFetchCommandHelper.process(CellFetchCommandHelper.jav
a:88)
>>  at org.zkoss.zss.ui.au.in.CellFetchCommand.process(CellFetchCommand.java:34)
>>  at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:3337)
>>  at org.zkoss.zk.ui.impl.DesktopImpl.service(DesktopImpl.java:607)
>>  at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1258)
>>...

If a cell has special text format and associated with Hyperlink, the displayed 
text should be the format one.

ZK Spreadsheet 1.x work with ZK 3 only. Need a version to work with ZK 5+.

For hidden rows, shall not show.

Picture is not correctly shown (ZK Spreadsheet EE)

Support Range.fillRight

Can set borers around cells.

Support Range.fillLeft()

What steps will reproduce the problem?
1. Check out the latest source
2. Build the project with dependencies
3. Run in on apache

What is the expected output? What do you see instead?
SpreadSheet App

What version of the product are you using? On what operating system?
2.0 Beta, Windows Vista

Please provide any additional information below.


Component definition not found: colorbutton in [LanguageDefinition:
xul/html], [SYS
file:/C:/Users/Test/Documents/NetBeansProjects/Excel/build/web/index.zul
line 385 col 108]

And once the colour button definition is commented?

org.zkoss.zk.ui.metainfo.DefinitionNotFoundException: Component definition
not found: spreadsheet in [LanguageDefinition: xul/html], [SYS
file:/C:/Users/Test/Documents/NetBeansProjects/Excel/build/web/index.zul
line 444 col 45]

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


Please use labels and text to provide additional information.

Support Range.autoFill

The height of the inserted row shall be the same as it previous Row or default 
height if no previous row.

Hello,
I had tried the 2.0.0 beta2 version and found this problem:

org.zkoss.zss.model.impl.BookHelper.getPictures(Lorg/apache/poi/ss/usermodel/She
et;)Ljava/util/List;
java.lang.NoSuchMethodError: 
org.zkoss.zss.model.impl.BookHelper.getPictures(Lorg/apache/poi/ss/usermodel/She
et;)Ljava/util/List;
    at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.onSheetSelected(DefaultBookWidgetLoader.java:90)
    at org.zkoss.zss.ui.Spreadsheet.doSheetSelected(Spreadsheet.java:2859)
    at org.zkoss.zss.ui.Spreadsheet.getSelectedSheet(Spreadsheet.java:426)

Support clear the content of a range.

When ZK Spreadsheet 1.x import and showing the excel xls file on the
browser , the column width on each column is not consistent with what is
shown on the Excel application. Need to make it consistent with the Excel.

Can insert an area and move cells right or down.

Sort sorting by Rows (change column order)

Can un-hide rows within the specified range.

Can merge a specified range.

Can set a new row height to specified rows and update ui.

The inserted column width shall be the same as it previous column.

Support insert rows into spreadsheet

Able to remove rows from the spreadsheet component.

Can paste All, value only, partial style to this range from server 
Clipboard(inter ZK Spreadsheet).

Able to insert columns and handle formula shift.

Can click on a hyperlink cell and change focus to the specified hyperlink 
target.

Can un-merge a merged cell.

Can set a new column width to a range and update the ui.

Support showing chart

java.lang.NullPointerException
    at org.zkoss.zss.ui.impl.Utils.getRichEditText(Utils.java:337)
    at org.zkoss.zss.ui.impl.Utils.getEditText(Utils.java:304)
    at
com.adobe.portal.zss.app.MainWindowCtrl.FocusedEvent(MainWindowCtrl.java:528)