ReoGrid icon indicating copy to clipboard operation
ReoGrid copied to clipboard

"Centred across selection" alignment not honoured

Open GrahamTheCoder opened this issue 3 years ago • 0 comments

Description

Loading from xlsx does not honour "centered across selection" alignment. If it's too much work to support, it may be worth just interpreting as "center" for now

To Reproduce

SingleCentredAcrossSelectionCell.xlsx Either download this, or just create a new Excel worksheet with some text in cell A1 that is "centred across selection": image

I'm using a reasonably recent version of Excel, but can also reproduce creating the file with a library from a few years back, so I don't think anything is new there.

Install <PackageReference Include="unvell.ReoGridWPF.dll" Version="3.0.0" />

            _grid.Load(@"C:\path\to\SingleCentredCell.xlsx", FileFormat._Auto);

Expected: Centred within the specified cells Actual: Left aligned

How that alignment works is explained on various sites you can find on Google: https://exceljet.net/lessons/how-to-use-center-across-selection-in-excel

Screenshots

image

Edition

Which edition of ReoGrid do you using?

  • WPF

Environment

  • OS: Windows 10
  • Language of OS: English

Many thanks for providing this fantastic library 😄

GrahamTheCoder avatar Jun 16 '21 17:06 GrahamTheCoder