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

Merged cells are shifted after scrolling

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.8.1
    • Fix Version/s: 3.8.2
    • Component/s: None
    • Security Level: Jean
    • Labels:
      None
    • gh.sprint.customfield.default.name:
      Sprint 1

      Description

      Steps to reproduce

      1. load the zul and attached Excel file
        <zk>
        <spreadsheet id="ss" src="/WEB-INF/issue/header-example.xlsx" maxVisibleRows="800" maxVisibleColumns="111" width="50%" 
        		height="100%" 
        		showContextMenu="true" showSheetbar="true" showToolbar="true" showFormulabar="true" 
        		/>
        </zk>
        
      2. scroll to right most end quickly
      3. scroll to left for 40 columns at least

      Actual result

      Merges cells are shifted left

      Workaround

      Scroll to left most end

      Debug information

      • no javascript error when the issue happens
      • reproducing rate 50%, you need to reload and try
      1. header-example.xlsx
        150 kB
        hawk
      1. rowNotRendered.png
        89 kB
      2. shifted.jpg
        37 kB
      3. shiftedMergedCells.png
        12 kB

        Issue Links

          Activity

          Hide
          henrichen henrichen added a comment -

          Fixed.

          Show
          henrichen henrichen added a comment - Fixed.
          Hide
          hawk hawk added a comment - - edited

          Test the latest fix with 3.8.2-SNAPSHOT
          1. When loading the file and scrolling, the same javascript error happens multiple times:

          zssex.wpd:4105 Uncaught TypeError: Cannot read property 'updateRowAutoHeight' of null
          zk.override.fireProcessAutoHeight_ @ zssex.wpd:4105zss.SSheetCtrl.zk.$extends.onContentsChanged @ zss.wpd:17100zk.Widget.zk.$extends.fireX @ zk.wpd:17029zk.Widget.zk.$extends.fire @ zk.wpd:17077zss.Spreadsheet.zk.$extends.onResponse @ zss.wpd:1218_invoke @ zk.wpd:12614zk.$extends.fire @ zk.wpd:12597(anonymous function) @ zk.wpd:12735setTimeout (async)_fire @ zk.wpd:12734inf.fire @ zk.wpd:12831zk.override.fire @ zk.wpd:14137doCmdsNow @ zk.wpd:19545zAu._doCmds @ zk.wpd:19780afterResponse @ zk.wpd:19424onResponseReady @ zk.wpd:19421XMLHttpRequest.send (async)ajaxSendNow @ zk.wpd:19484zAu.sendNow @ zk.wpd:19938(anonymous function) @ zk.wpd:19463
          2. After scrolling to the right, The rendering time takes longer time than before obviously.

          Show
          hawk hawk added a comment - - edited Test the latest fix with 3.8.2-SNAPSHOT 1. When loading the file and scrolling, the same javascript error happens multiple times: zssex.wpd:4105 Uncaught TypeError: Cannot read property 'updateRowAutoHeight' of null zk.override.fireProcessAutoHeight_ @ zssex.wpd:4105zss.SSheetCtrl.zk.$extends.onContentsChanged @ zss.wpd:17100zk.Widget.zk.$extends.fireX @ zk.wpd:17029zk.Widget.zk.$extends.fire @ zk.wpd:17077zss.Spreadsheet.zk.$extends.onResponse @ zss.wpd:1218_invoke @ zk.wpd:12614zk.$extends.fire @ zk.wpd:12597(anonymous function) @ zk.wpd:12735setTimeout (async)_fire @ zk.wpd:12734inf.fire @ zk.wpd:12831zk.override.fire @ zk.wpd:14137doCmdsNow @ zk.wpd:19545zAu._doCmds @ zk.wpd:19780afterResponse @ zk.wpd:19424onResponseReady @ zk.wpd:19421XMLHttpRequest.send (async)ajaxSendNow @ zk.wpd:19484zAu.sendNow @ zk.wpd:19938(anonymous function) @ zk.wpd:19463 2. After scrolling to the right, The rendering time takes longer time than before obviously.
          Hide
          henrichen henrichen added a comment -

          Fixed the reopen.

          > Side effect
          > after scrolling right 20 columns, zss doesn't render rows after row 21 for over 30 seconds

          This should be caused by ZSS-1116 originally bad fixing(which caused severe performance issue) and is gone after we revert ZSS-1116.

          Show
          henrichen henrichen added a comment - Fixed the reopen. > Side effect > after scrolling right 20 columns, zss doesn't render rows after row 21 for over 30 seconds This should be caused by ZSS-1116 originally bad fixing(which caused severe performance issue) and is gone after we revert ZSS-1116 .

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Agile