ReoGrid
ReoGrid copied to clipboard
Bug with opening excel files that contain fraction numbers
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
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.
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?
Nope, no special formatting, the excel is encoded in UTF-8