Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/ClosedXML/ClosedXML/issues/1887 below:

System.NotImplementedException in ConvertLegacyCellValueToScalarValue for integer value · Issue #1887 · ClosedXML/ClosedXML · GitHub

Do not randomly delete sections. They are here for a reason.

Do you want to request a feature or report a bug?

• Bug
• Feature
• Question

Did you test against the latest CI build?

• Yes
• No

If you answered No, please test with the latest development build first.

Version of ClosedXML

0.97.0

What is the current behavior?

Throws System.NotImplementedException: Not sure how to get convert value 0 (type Int32) to AnyValue.

What is the expected behavior or new feature?

Should treat Int32 value as ordinary numeric value.

Is this a regression from the previous version?

No.

This is an important section. Read it carefully. Failure to do so will cause a 'RTFM' comment.

Without a code sample, it is unlikely that your issue will get attention. Don't be lazy. Do the effort and assist the developers to reproduce your problem. Code samples should be minimal complete and verifiable. Sample spreadsheets should be attached whenever applicable. Remove sensitive information.

Code to reproduce problem:

using ClosedXML.Excel;

public void Main()
{
	using( var wb = new XLWorkbook( ) ) {
		var ws = wb.Worksheets.Add("Sample Sheet");
		ws.Cell( "A1" ).FormulaA1 = "=A2";
		ws.Cell( "A10" ).FormulaA1 = "=SUM(A1:A9)";

		Console.WriteLine( $"A10={ws.Cell( "A10" ).Value}" );
	}
}

• I attached a sample spreadsheet. (You can drag files on to this issue)

PS : Pull request will follow

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4