Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-789

exporting a sheet unhide hidden rows

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 6.0.0
    • 5.10.0, 5.12.2
    • None
    • None

      Steps to Reproduce

      1. export keikai-789.xlsx
      2. check hidden rows at 60, 66, 76,77 in the exported xlsx

      Current Result

      those hidden rows are visible

      Expected Result

      those hidden rows are still invisible

      Debug Information

      • keikai 6.0 cannot reproduce this bug
      • the w

      Workaround

      • manually copy rows and column width from the original problematic sheet to a new sheet
      • AbstractExcelExporter
        	protected void exportRow(SSheet sheet, Sheet poiSheet, SRow row) {
        		_exportPhase.setPhase(ExportPhase.ROW);
        		int rowIndex = row.getIndex();
        		_exportPhase.setRowIndex(rowIndex);
        		Row poiRow = poiSheet.createRow(rowIndex);
        
        		if (row.isHidden()) {
        			// hidden, set height as 0
        			poiRow.setZeroHeight(true);
        			poiRow.setCustomHeight(true); // KEIKAI-789 enforce custom height to make it hidden
        

            Unassigned Unassigned
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: