Deyan Yosifov
Team Member

SpreadProcessing: Split Panes

Split allows you to split the window into different panes that each scroll separately.

This feature is different than the horizontal/vertical split of freeze panes, which is supported.
Feature Request by Deyan Yosifov Status: Approved Comments: 0 Category: RadSpreadProcessing Last update: 2017-09-26T13:52:31 by Borislav Ivanov
0
Deyan Yosifov
Team Member

SpreadProcessing: Support for Macro-Enabled Workbooks

Feature Request by Deyan Yosifov Status: Declined Comments: 1 Category: RadSpreadProcessing Last update: 2017-09-26T13:49:16 by Borislav Ivanov
0
Nikolay Demirev
Team Member

SpreadProcessing: Support for Macro-Enabled Workbooks (xlsm)

Add support for preserving and exporting the macros in a macro-enabled workbook.

Macros are pieces of code written in Visual Basic for Applications (VBA) which are used to automate repetitive tasks in excel. The macros are part of the excel file. When a file contains a macro its extension becomes xlsm.

SpreadProcessing should be able to import and export xlsm files and edit the macros in them.
Feature Request by Nikolay Demirev Status: Approved Comments: 0 Category: RadSpreadProcessing Last update: 2017-09-26T13:44:53 by Borislav Ivanov
0
Deyan Yosifov
Team Member

SpreadProcessing: Add the defaultThemeVersion attribute of Workbook Properties on export

When defaultThemeVersion is missing from the file, some styles are not shown when the document is opened in MS Excel.
Feature Request by Deyan Yosifov Status: Declined Comments: 1 Category: RadSpreadProcessing Last update: 2017-09-26T13:09:37 by Borislav Ivanov
0
Deyan Yosifov
Team Member

SpreadProcessing: Add support for Pivot Tables

Add support for pivot tables.
Feature Request by Deyan Yosifov Status: Approved Comments: 0 Category: RadSpreadProcessing Last update: 2017-09-26T07:14:18 by Borislav Ivanov
0
Tanya Dimitrova
Team Member

SpreadProcessing: Improve performance of Worksheet.UsedCellRange after import

The value of Worksheet.UsedCellRange could be calculated during the import of the workbook - as all cells are processed anyway. This will improve the performance of the first usage of this property, which is very common scenario. Also xlsx documents can have optional 'dimension' element which is used to specify the used cell range:

<dimension ref="A1:C2"/>.
Feature Request by Tanya Dimitrova Status: Approved Comments: 0 Category: RadSpreadProcessing Last update: 2017-09-26T06:49:12 by Borislav Ivanov
0
Tanya Dimitrova
Team Member

SpreadProcessing: Introduce support for functions with '_xlfn.' prefix (future functions)

Some functions are exported from Excel with the _xlfn. prefix as compatibility measure with older versions of MS Excel (future functions, see here https://msdn.microsoft.com/en-us/library/dd907480(v=office.12).aspx , https://support.office.com/en-ca/article/Issue-An-xlfn-prefix-is-displayed-in-front-of-a-formula-882f1ef7-68fb-4fcd-8d54-9fbb77fd5025 )

RadSpreadProcessing do not support these and the spreadsheet treats the function as not supported even when it is.

Example:

<row r="1" spans="2:2" x14ac:dyDescent="0.25">
<c r="B1" t="b">
<f>_xlfn.ISFORMULA(C2)</f>
<v>0</v>
</c>
</row>


This could be observed with the ISFORMULA function.
Feature Request by Tanya Dimitrova Status: Approved Comments: 0 Category: RadSpreadProcessing Last update: 2017-09-25T14:04:39 by Borislav Ivanov
0
Tanya Dimitrova
Team Member

SpreadProcessing: Implement API for checking if a Worksheet or a Workbook is empty

Now there is no public API that allows the users to check if a Worksheet is empty or not. The UsedCellRange property returns a cell range that is only the cell A1 even if it is empty too.

Possible solution is to expose IsEmpty property of the CellRange.

Workaround: Check if Worksheet.UsedCellRange contains only A1, and that additionally A1 is empty.
Feature Request by Tanya Dimitrova Status: Approved Comments: 0 Category: RadSpreadProcessing Last update: 2017-09-25T13:56:33 by Borislav Ivanov
0
ARKADIY MOSKOVSKIY

SpreadProcessing: Change SpreadsheetNameCollectionScope properties CurrentWorksheet and Workbook access modifier to public (now internal)

When I need to populate a cell that I find using a DefinedName I should parse RefersTo to get Worksheet name. But DefinedName class contains Scope property which has CurrentWorksheet and Workbook properties (internal). It would be very useful if these properties could be public.
Feature Request by ARKADIY MOSKOVSKIY Status: Declined Comments: 1 Category: RadSpreadProcessing Last update: 2017-09-25T12:03:19 by Borislav Ivanov
0
Deyan Yosifov
Team Member

ZipLibrary: Implement GZIP compression and decompression

Feature Request by Deyan Yosifov Status: Approved Comments: 1 Category: RadZipLibrary Last update: 2017-09-21T18:58:21 by David Totzke
0
Displaying items 1 - 10 of 369