MergedColumnsWidth += column.ColumnWidth If ((bool)subRange.MergeCells & subRange.Value != null)įoreach (dynamic column in mergedArea.Columns)
Var subRange = range.GetSubRange(rowIndex, columnIndex)
public static void AutoFitRowsWithMergedCells(this Worksheet worksheet)įor (int rowIndex = 1 rowIndex <= rowsCount rowIndex++)įor (int columnIndex = 1 columnIndex <= columnsCount columnIndex++) When I find merged cell I copy it's sizes and value into not merged temporary cell before last used column in same row, executes AutoFit(), witch now works correctly and removes temp cell. After filling Worksheet with data, I use my ExtensionMethod mySheet.AutoFitRowsWithMergedCells() RowHeight = IIf(CurrentRowHeight > PossNewRowHeight, _
#GEMBOX SPREADSHEET MERGE PDF#
If you want to create complex PDF documents, use GemBox.Document, GemBox.Spreadsheet, and GemBox.Presentation, which all have PDF exporting capability. NET applications in a simple and efficient way. Cells(1).ColumnWidth = MergedCellRgWidth NET component that enables developers to read, write, merge and split PDF files or execute low-level object manipulations from. MergedCellRgWidth = CurrCell.ColumnWidth + MergedCellRgWidth Set MergeRng = Union(MergeRng, c.MergeArea) 'Create an array of merged cell addresses that have wrapped text Source credits parry from Sub AutoFitMergedCellRowHeight()ĭim CurrentRowHeight As Single, MergedCellRgWidth As Singleĭim ActiveCellWidth As Single, PossNewRowHeight As Singleĭim StartCell As Range, c As Range, MergeRng As Range, Cell As Range Perhaps you can convert this into C#, but I found a VB macro here that will simulate the autofit of any merged cells on the active sheet.
0 kommentar(er)
