ReoGrid icon indicating copy to clipboard operation
ReoGrid copied to clipboard

Bug with opening excel files that contain fraction numbers

Open azurl2 opened this issue 5 years ago • 2 comments

OriginalExcelReogrid.Load(path, FileFormat.Excel2007);

OriginalExcelReogrid.CurrentWorksheet.SetScale(0.7f);
OriginalExcelReogrid.CurrentWorksheet.SetColumnsWidth(0, 1000, 120);
OriginalExcelReogrid.CurrentWorksheet.SetRowsHeight(0, 1000, 30);

OriginalPathHolder.Text = path;
_selectedFile = path;

CheckIfCanEnableConvert();

OriginalExcelReogrid.CurrentWorksheet.SelectionRangeChanged += (sender, args) =>
{
         _currentSelection = args.Range;
};

Describe the bug Loading an excel containing cells that are fraction numbers, for example G5/2 and the displayed format of those cells turns into datetime.

To Reproduce just load an excel.

Expected behavior Expected behavior is to display the excel as it shows up when I open it in excel.

Screenshots image

image

Edition Which edition of ReoGrid do you using?

  • WPF .net core 3.1

Environment (please complete the following information):

  • OS: Windows 10
  • Language of OS: English

Additional context using the latest version available to me in nuget, even ticked the prerelease box.

azurl2 avatar Feb 25 '20 13:02 azurl2

I just created a blank Excel file and set a cell as a currency format. Open it with ReoGrid, I can't confirm the problem. Does Excel have some cell format settings?

jingwood avatar Mar 06 '20 03:03 jingwood

Nope, no special formatting, the excel is encoded in UTF-8

image

azurl2 avatar Mar 10 '20 07:03 azurl2