exporting a sheet unhide hidden rows

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 6.0.0
    • Affects Version/s: 5.10.0, 5.12.2
    • Component/s: None
    • 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
        

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

              Created:
              Updated:
              Resolved: