Unplanned
Last Updated: 18 Aug 2022 09:09 by Rui
Created by: Rui
Comments: 0
Category: Spreadsheet
Type: Bug Report
3
Add formula error checking like in Excel
Unplanned
Last Updated: 16 Aug 2022 11:38 by ADMIN
Exporting merged columns to PDF creates unnecessary pages. The created file contains more than 8 MB in size and empty pages. It should create only one page as done in MS Excel.
Unplanned
Last Updated: 16 Aug 2022 11:29 by ADMIN
Selected merged cells jump to the bottom of the selection when it goes outside the visible area.
Completed
Last Updated: 16 Aug 2022 06:43 by ADMIN
Release LIB 2022.2.822 (22 Aug 2022)
Selecting the whole column and then opening the Charts dialog makes the app hang
Completed
Last Updated: 16 Aug 2022 06:18 by ADMIN
Release LIB 2022.2.822 (22 Aug 2022)
Spreadsheet :Export/Import of merged cells from several columns leads to - 'A' is invalid row name error
Completed
Last Updated: 09 Aug 2022 04:30 by ADMIN
Release LIB 2022.2.815 (15 Aug 2022)
Created by: Petar
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
Having more than one rule over a cell range and managing the rules through the "Manage Rules" dialog so they switch priority does nothing and the cells do not update.
Completed
Last Updated: 19 Jul 2022 14:16 by ADMIN
Release LIB 2022.2.725 (25 Jul 2022)
Copy-Paste rules action is not translating the rule range.
Completed
Last Updated: 19 Jul 2022 14:06 by ADMIN
Release LIB 2022.2.725 (25 Jul 2022)
The fill handle is not working with conditional formatting rules.
Completed
Last Updated: 19 Jul 2022 14:04 by ADMIN
Release LIB 2022.2.725 (25 Jul 2022)
New rows cannot be inserted when a rule is applied over the whole column.
Completed
Last Updated: 19 Jul 2022 14:01 by ADMIN
Release LIB 2022.2.725 (25 Jul 2022)
Reapplying rule to а different range is not being applied.
Completed
Last Updated: 19 Jul 2022 13:56 by ADMIN
Release LIB 2022.2.725 (25 Jul 2022)
The conditional formatting rule is not applied over shifted cells when a new row or a column is inserted or removed.
Completed
Last Updated: 04 Jul 2022 07:23 by ADMIN
Release LIB 2022.2.704 (04 Jul 2022)
Custom styles are not visible in the style gallery after importing a document.
Unplanned
Last Updated: 16 Jun 2022 07:16 by ADMIN
ADMIN
Created by: Tanya
Comments: 3
Category: Spreadsheet
Type: Feature Request
12
XLSB is binary format that should theoretically allow fast reading and writing to the file. 
Unplanned
Last Updated: 10 Jun 2022 06:02 by IGK
Created by: IGK
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

With the current implementation, the Notes support only a rectangular shape.

Examples:

Completed
Last Updated: 07 Jun 2022 07:28 by ADMIN
Release LIB 2022.2.613 (13 Jun 2022)

The button should always be active. 

The button:

Completed
Last Updated: 30 May 2022 11:23 by ADMIN
Release LIB 2022.2.606 (06 Jun 2022)

When the Freeze Panes option is enabled and try to insert a new comment into the next cell on the left to the Freeze Panes separator the comment is deleted.

Completed
Last Updated: 30 May 2022 09:26 by ADMIN
Release LIB 2022.2.530 (30 May 2022)
InvalidOperationException thrown by RowColumnHeadingBase.get_NormalFillBrush() with Crystal theme.
Completed
Last Updated: 26 May 2022 11:09 by ADMIN
Release LIB 2022.2.530 (30 May 2022)
When replying to someone else`s SpreadsheetComment, the SpreadsheetCommentReply`s author copies the comments author instead of passing the current author`s name.
Completed
Last Updated: 17 May 2022 11:29 by ADMIN
Release R2 2022
ADMIN
Created by: Petya
Comments: 6
Category: Spreadsheet
Type: Feature Request
27
Add support for conditional formatting of cells - allow applying of rules used during visualization of cells to automatically apply formatting depending on their values.
Unplanned
Last Updated: 06 May 2022 08:14 by IGK

Custom style is not applied to empty cells when applying to the entire row.

Workaround: 

Dim usedCellRange As CellRange = mobjValidationResultWs.UsedCellRange
For rowIndex As Integer = usedCellRange.FromIndex.RowIndex To usedCellRange.ToIndex.RowIndex
    For columnIndex As Integer = usedCellRange.FromIndex.ColumnIndex To usedCellRange.ToIndex.ColumnIndex
        Dim cell As CellSelection = mobjValidationResultWs.Cells(rowIndex, columnIndex)
        cell.SetStyleName("Common")

    Next columnIndex
Next rowIndex