Hello,
we would like to have the capability to create a chart in excel export using Telerik.Documents.Spreadsheet
Marcos
If a worksheet spans more than one page, you can print row and column headings or labels (also called print titles) on every page to ensure that the data is properly labeled.
Implement functionality to rotate the content of a cell.
Example:
<sheetViews>
<sheetView tabSelected="1" view="pageBreakPreview" zoomScaleNormal="100" zoomScaleSheetLayoutView="100" workbookViewId="0">
<selection activeCell="J5" sqref="J5"/>
</sheetView>
</sheetViews>
Currently, similar conversions should be manually implemented by the users.
Sample method that could be used:
public static Color HexStringToColor(string hexColor)
{
// Remove the # at the front.
if (hexColor.StartsWith("#"))
{
hexColor = hexColor.Substring(1, hexColor.Length - 1);
}
byte a = 255;
byte r = 255;
byte g = 255;
byte b = 255;
int start = 0;
// Handle ARGB strings (8 characters long).
if (hexColor.Length == 8)
{
start = 2;
}
//Handle contracted RGB strings (3 characters long)
if (hexColor.Length == 3)
{
hexColor = string.Format("{0}{0}{1}{1}{2}{2}", hexColor[0], hexColor[1], hexColor[2]);
}
else if (hexColor.Length < 6)
{
hexColor = hexColor.PadLeft(6, '0');
}
// Convert RGB characters to bytes.
r = byte.Parse(hexColor.Substring(start, 2), NumberStyles.HexNumber);
g = byte.Parse(hexColor.Substring(start + 2, 2), NumberStyles.HexNumber);
b = byte.Parse(hexColor.Substring(start + 4, 2), NumberStyles.HexNumber);
return Color.FromArgb(a, r, g, b);
}
Provide ability for working with comments in a spreadsheet document.
In Office 365 there are two types of comments:
This item applies to Threaded Comments only.
For Notes, please follow: SpreadProcessing: Provide API for Insert / Delete Comments (Notes)
Implement support for cell references to columns and rows, e.g. $1:$2, A:D, etc. Currently, CellSelection.SetValue throws ParseException, and CellSelection.SetValueAsFormula throws InvalidOperationException.
From the OOXML Specification: A comment is a rich-text note that is attached to and associated with a cell, separate from other cell content.
In Office 365 there are two types of comments:
This item applies to Comments/Notes only.
For Threaded Comments, please follow: SpreadProcessing: Comments (Threaded Comments)
Add support for conditional formatting of cells - allow applying of rules used during visualization of cells to automatically apply formatting depending on their values.
When a csv is exported the entire range which has values is exported. When export is done in Excel, the cells of this range which are empty are marked by an additional field, separated by a comma. This comma is present in SpreadProcessing only in places where it is obligatory for example in the middle of the row. Obligatory comma in this context means that without it the file will not be read correctly by Excel or SpreadProcessing. In places where it is not obligatory, like in an empty row or in the end of the row, it is skipped. These non-obligatory commas do not influence how the file will be interpreted by Excel, however, according to the most-popular csv spec, they should be present, which means that there could be parsers which are unable to parse the resulting file. (2.4 Each line should contain the same number of fields throughout the file.) Example: Exported by Excel: --------------------------------------- Product,Unit Price,Units in Stock,Discontinued Chai,$18.00 ,39, Chang,,17, Chef Anton's Cajun Seasoning,$22.00 ,53,No ,,, Chef Anton's Gumbo Mix,$21.35 ,0,No --------------------------------------- Exported by SpreadProcessing: --------------------------------------- Product,Unit Price,Units in Stock,Discontinued Chai,$18.00 ,39 Chang,,17 Chef Anton's Cajun Seasoning,$22.00 ,53,No Chef Anton's Gumbo Mix,$21.35 ,0,No --------------------------------------- Note the extra commas in the empty row and in the end of the first two rows in the SpreadProcessing sample.
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.
Expose an easy way to create .xlsx documents from DataTable objects.
The cell contains the following data in OOXML: <f>SUM(1,2,3)</f> - The formula <v>6</v> - the calculated value The formula value is imported, but the calculated value is skipped. The feature will be useful if Manual calculation option is supported: https://feedback.telerik.com/Project/184/Feedback/Details/191275-spreadsheet-add-support-for-different-calculation-options-automatic-or-manual