Unplanned
Last Updated: 19 May 2022 12:32 by Rik
Rik
Created on: 19 May 2022 12:32
Category: SpreadProcessing
Type: Bug Report
1
SpreadProcessing: Properties applied on row/column selection are not respected by used cells when exporting to XLSX

The values applied to the row/column should be explicitly set on each used cell as well. Otherwise, if they are applied on row/column only, the used cells don't use the desired values when opening the document.

To reproduce:

  1. Set some content on cell A1
  2. Create a row selection and apply a fill color to it (or any other property)
  3. Export the document and open it in an application

Observed: All cells except A1 have the specified color.

Workaround: Use cell selection, e.g.:

sheet.Cells[0,10].SetFill(PatternFill.CreateSolidFill(Colors.Red));

0 comments