In Development
Last Updated: 21 Sep 2020 08:04 by ADMIN
When the associated document style is not of type StyleType.Table (does not contain TableProperties) a NullReferenceException is thrown.
Unplanned
Last Updated: 18 Sep 2020 08:45 by ADMIN
ADMIN
Created by: Nikolay Demirev
Comments: 15
Category: SpreadProcessing
Type: Feature Request
16
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.
Unplanned
Last Updated: 18 Sep 2020 05:47 by ADMIN
Introduce support for the "page-break-inside" tag when importing an HTML
Unplanned
Last Updated: 17 Sep 2020 10:24 by ADMIN

When a TrueType font is defined, the mapping of character codes to glyph indices depends on the built-in cmap table mappings defined in the font and the Encoding property defined in the PDF dictionary.

However, the current implementation maps all characters with cmap tables for Microsoft Symbolic and Macintosh Roman, which causes incorrect mapping results, e.g. space characters are mapped to an Ê glyph.

The issue is also described in the following public item: TryGetCharCode for OpenTypeFont uses wrong cmap and returns wrong charcode.

Workaround: Change the font  of the TextBoxField's widget appearance:
foreach (var widget in field.Widgets)
{
    widget.TextProperties.Font = FontsRepository.Helvetica;
}

Unplanned
Last Updated: 17 Sep 2020 10:06 by ADMIN
For example when some PDF file has uncompressed contents we may import it and apply better compression to the stream objects. Ensure that all the content inside the document is compressed.
Completed
Last Updated: 16 Sep 2020 12:44 by ADMIN
Release R3 2020
ADMIN
Created by: Deyan
Comments: 6
Category: SpreadProcessing
Type: Feature Request
41

					
			
Completed
Last Updated: 16 Sep 2020 12:41 by ADMIN
Release R3 2020
Created by: Dimitar
Comments: 2
Category: SpreadProcessing
Type: Bug Report
1

To reproduce: 

- Add the following formula to a cell: "=A1=FALSE"

Actual: the result is always false

Expected: the result should be true when the cell is empty

 

Workaround: Use the ISBLANK function.

Completed
Last Updated: 16 Sep 2020 12:17 by ADMIN
Release R3 2020
This exception corrupts the whole document import. Instead, we should provide Exception handling mechanism which allows the user to import the rest of the content.
Completed
Last Updated: 16 Sep 2020 12:16 by ADMIN
Release R3 2020
More information is available in the Pdf Reference 1.7. Page 442 lists all predefined CMaps that should be imported and exported as PdfName objects. At this point, trying to import a document with such encoding, a NotSupportedException is thrown with message Encoding type is not supported.
Completed
Last Updated: 16 Sep 2020 11:59 by ADMIN
Release R3 2020
Created by: Pochun
Comments: 0
Category: PdfProcessing
Type: Feature Request
1
Currently Type0Font class has CMap that can only be Identity-H. The Identity-V is a vertical version of Identity−H. The mapping is the same as for Identity−H.
Unplanned
Last Updated: 16 Sep 2020 04:41 by ADMIN
When importing an embedded Type 1 Font with custom encoding an InvalidCastException is thrown.
Unplanned
Last Updated: 15 Sep 2020 10:14 by ADMIN
The chart size is not correctly set when the TwoCellAnchor contains similar elements
Unplanned
Last Updated: 11 Sep 2020 10:01 by ADMIN
The negative margin is not respected when exporting to pdf.
Unplanned
Last Updated: 04 Sep 2020 11:20 by ADMIN
After a PDF document is imported, decoding large images with a CCITTFaxDecode filter leads to OutOfMemoryException.
Unplanned
Last Updated: 04 Sep 2020 06:04 by ADMIN
Exporting a sheet in a workbook, results in clearly narrower column widths, this doesn't appear to be a scaling issue as letters that extend outside of a cell are occluded differently from the Excel document. Also worth noting, borders adjacent to the margin area are clipped (not an issue when exporting the same PDF from excel), text padding in the cell is not the same as the Excel document, and borders disappear unexpectedly on some text cells 
Unplanned
Last Updated: 03 Sep 2020 09:33 by ADMIN
ADMIN
Created by: Deyan
Comments: 8
Category: SpreadProcessing
Type: Feature Request
28
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.
Completed
Last Updated: 01 Sep 2020 08:52 by ADMIN
Release R3 2020
When importing color space defined as an external resource name, a NotSupportedColorSpaceException: 'CS0 color space is not supported.' is thrown.
Unplanned
Last Updated: 31 Aug 2020 06:14 by ADMIN

Handle the case where the formula starts with "=+". Detailed information: https://professor-excel.com/equal-plus-excel-formulas/

Workaround: replace the "=+" with "="

CellRange usedCellRange = workbook.Worksheets[0].UsedCellRange;

for (int rowIndex = usedCellRange.FromIndex.RowIndex; rowIndex <= usedCellRange.ToIndex.RowIndex; rowIndex++)
{
    for (int columnIndex = usedCellRange.FromIndex.ColumnIndex; columnIndex <= usedCellRange.ToIndex.ColumnIndex; columnIndex++)
    {
        CellSelection cell = workbook.Worksheets[0].Cells[rowIndex, columnIndex];
       

        FormulaCellValue formulaCellValue =cell.GetValue().Value as FormulaCellValue;
        if (formulaCellValue == null)
        {
            continue;
        }
        CellValueFormat format = cell.GetFormat().Value;
        string resultValueAsString = formulaCellValue.GetValueAsString(format);
        Console.WriteLine(resultValueAsString);
        if (resultValueAsString.StartsWith("=+"))
        {
            resultValueAsString = resultValueAsString.Remove(1, 1);
            cell.SetValue(resultValueAsString);
        }
    }
}
radSpreadsheet.Workbook = workbook;

 

Completed
Last Updated: 28 Aug 2020 07:36 by ADMIN
Release LIB 2020.2.831 (31/08/2020)
NullReferenceException is thrown when importing a PDF document containing InlineImage with missing parameters
Completed
Last Updated: 28 Aug 2020 07:16 by ADMIN
Release LIB 2020.2.831 (31/08/2020)
The EI keyword defines an operator for ending the image data. When the stream contains the same sequence, the parser treats that as an end of the image data. As a result, the image and the following content cannot be properly parsed and there is missing content when the document is visualized.
1 2 3 4 5 6