https://bugs.documentfoundation.org/show_bug.cgi?id=99099
Bug ID: 99099 Summary: Addition of new rows in Spreadsheet in not inheriting previous row attributes in .xlsx but inheriting in .xls Product: LibreOffice Version: 5.0.4.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: jvchb...@gmail.com We use LibreOffice to convert .xls documents to .xls and xlsx documents. We use MS Excel 97 filter to produce xls documents and Calc MS Excel 2007 XML to produce .xlsx documents. We use conditional formatting for one column to apply background color for the cell. It works fine for .xls with MS Excel 97 filter but fails for .xlsx with Calc MS Excel 2007 XML filter.It outputs the cells without applying conditional formatting for .xlsx. The code we use for additions of new rows for both .xls and .xlsx is same. So the issue is with Calc MS Excel 2007 XML filter only as MS Excel 97 filter is working absolutely fine. Code Snippet used for generating new rows: ------------------------------------------- public void insertCells(XSpreadsheet xSheet, int left, int top, int right, int bottom, int num, CellInsertMode nMode) { try { XCellRangeMovement xMovement = (XCellRangeMovement) UnoRuntime.queryInterface(XCellRangeMovement.class, xSheet); if (num <= 0) { // don't do anything return; } if (nMode == CellInsertMode.DOWN || nMode == CellInsertMode.ROWS) { // only expand row cells top = bottom + 1; bottom = top + num - 1; } else if (nMode == CellInsertMode.RIGHT || nMode == CellInsertMode.COLUMNS) { // only expand column cells left = right + 1; right = left + num - 1; } CellRangeAddress addrRange = null; XCellRangeAddressable xAddr = (XCellRangeAddressable) UnoRuntime.queryInterface( XCellRangeAddressable.class, xSheet.getCellRangeByPosition(left, top, right, bottom)); addrRange = xAddr.getRangeAddress(); xMovement.insertCells(addrRange, nMode); Please let us know if more information is required to reproduce the issue. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs