Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-1174

The preloadColumnSize and preloadRowSize doesn't work as expected

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.8.3
    • 3.8.2
    • None
    • Security Level: Jimmy
    • None
    • Sprint 3

      steps to reproduce

      1. open dev tool /network tab
      2. load the zul with the attached file
        <zk>
        	<spreadsheet id="ss2" src="/WEB-INF/excel/preload.xlsx" showToolbar="true" maxVisibleRows="100" maxVisibleColumns="100" width="700px"
        		height="500px" preloadColumnSize="100" preloadRowSize="100"/>	
        </zk>
        
      3. constantly move selection box to the right with right arrow key to column 22

      result

      onZSSCellFetch is sent when moving to column 22, then every 2 columns move by the right arrow key triggers an onZSSCellFetch being sent.
      Moving down to row 22 also triggers the event, then every 2 rows move by the key triggers an onZSSCellFetch being sent.

      expected result

      At the beginning,
      dtid:z_1pg
      cmd_0:onZSSSyncBlock
      uuid_0:b99P0
      data_0:

      {"sheetId":"b99P0","dpWidth":8800,"dpHeight":2000,"viewWidth":683,"viewHeight":419,"blockLeft":0,"blockTop":0,"blockRight":20,"blockBottom":20,"fetchLeft":-1,"fetchTop":-1,"fetchWidth":-1,"fetchHeight":-1,"rangeLeft":0,"rangeTop":0,"rangeRight":99,"rangeBottom":99}

      the blockRight is 20 (21th column), with preloadColumnSize, zss should get 20+ (100/2) = 70 coulumns.
      It supposes to move more than 70 columns, then ZSS should fetch the data from the server.

        1. columnT.png
          92 kB
          hawk
        2. preload.xlsx
          110 kB
          hawk

            henrichen henrichen
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: