TdxSpreadSheetUnhideRows is not working when History=True. Check Test.zip.
Executing a TdxSpreadSheetCustomChangeSelectionVisibilityAction descendant causes the "Out of memory" exception if all cells are selected in a worksheet and the Undo/Redo history of actions is enabled
Answers approved by DevExpress Support
We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.
Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.
- v15.2.3Download Official Update
ChangeSelectedColumnsVisibility and ChangeSelectedRowsVisibility are also not working if "SelectAll" is active. I think to many rows/columns are selected in the Loop and History.BeginAction/EndAction is missing. Maybe other procedures have the same problem: TdxSpreadSheetMergeCellsAcross…
…
procedure TdxSpreadSheetCustomChangeSelectionVisibilityAction.ChangeSelectedColumnsVisibility(const AValue: Boolean);
var
ASheet: TdxSpreadSheetTableView;
AColumn: Integer;
begin
ASheet := ActiveTable;
ASheet.BeginUpdate;
try
// !!! Problem, when all columns are active (Select-All) !!!
for AColumn := ASheet.Selection.Area.Left to ASheet.Selection.Area.Right do
ASheet.Columns.CreateItem(AColumn).Visible := AValue;
finally
ASheet.EndUpdate;
end;
end;
…
I am using a procedure to check the selection rect. This should handle Select-All. Maybe helpfull:
…
procedure CheckSelectionRect
( const iSheet : TdxSpreadSheetTableView ;
var iRect : TRect ) ;
begin
{ Prüfen }
if dxSpreadSheetIsEntireColumn(iRect) then iRect.Bottom := iSheet.Rows.LastIndex ;
if dxSpreadSheetIsEntireRow(iRect) then iRect.Right := iSheet.Columns.LastIndex ;
end ;
…
Hello Thomas,
Thank you for your report. I have reproduced the described behavior and forwarded this ticket to our developers for research.