Skip to content

[POI-66083 & POI-66094] Support (FLOOR|CEILING).MATH & (VAR|STDEV).(P|S) functions #159

[POI-66083 & POI-66094] Support (FLOOR|CEILING).MATH & (VAR|STDEV).(P|S) functions

[POI-66083 & POI-66094] Support (FLOOR|CEILING).MATH & (VAR|STDEV).(P|S) functions #159

Triggered via pull request August 7, 2023 13:04
Status Failure
Total duration 15m 39s
Artifacts
This run and associated checks have been archived and are scheduled for deletion. Learn more about checks retention

PR.yml

on: pull_request
Fit to window
Zoom out
Zoom in

Annotations

18 errors and 20 warnings
ubuntu-latest
/usr/bin/chmod: cannot access '/usr/local/share/fonts/NotoColorEmoji.ttf': No such file or directory
ubuntu-latest
/usr/bin/cp: cannot create regular file '/usr/local/share/fonts/NotoColorEmoji.ttf': Permission denied
ubuntu-latest
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
ubuntu-latest
OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! POI will use only the first, but other software may reject this file.
ubuntu-latest
OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! POI will use only the first, but other software may reject this file.
updateColumnWidths_and_getBestFitColumnWidth: testcases/ooxml/XSSF/Streaming/TestAutoSizeColumnTracker.cs#L174
check column width: 0.2934083601286174, 365, 1244, 1609
ubuntu-latest
Target "Test" has thrown an exception
ubuntu-latest
Process completed with exit code 255.
windows-latest
OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! POI will use only the first, but other software may reject this file.
windows-latest
OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! POI will use only the first, but other software may reject this file.
windows-latest
OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! POI will use only the first, but other software may reject this file.
windows-latest
OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! POI will use only the first, but other software may reject this file.
TestEvaluate(CEILING: testcases/ooxml/SS/Formula/Functions/TestFloorCeilingMath.cs#L112
System.IO.FileLoadException : Could not load file or assembly 'ExtendedNumerics.BigDecimal, Version=2023.213.1010.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. A strongly-named assembly is required. (Exception from HRESULT: 0x80131044)
TestEvaluate(CEILING: testcases/ooxml/SS/Formula/Functions/TestFloorCeilingMath.cs#L112
System.IO.FileLoadException : Could not load file or assembly 'ExtendedNumerics.BigDecimal, Version=2023.213.1010.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. A strongly-named assembly is required. (Exception from HRESULT: 0x80131044)
TestEvaluate(FLOOR: testcases/ooxml/SS/Formula/Functions/TestFloorCeilingMath.cs#L112
System.IO.FileLoadException : Could not load file or assembly 'ExtendedNumerics.BigDecimal, Version=2023.213.1010.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. A strongly-named assembly is required. (Exception from HRESULT: 0x80131044)
TestEvaluate(FLOOR: testcases/ooxml/SS/Formula/Functions/TestFloorCeilingMath.cs#L112
System.IO.FileLoadException : Could not load file or assembly 'ExtendedNumerics.BigDecimal, Version=2023.213.1010.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. A strongly-named assembly is required. (Exception from HRESULT: 0x80131044)
EvaluateAllFormulas
Expected: No Exception to be thrown But was: <System.IO.FileLoadException: Could not load file or assembly 'ExtendedNumerics.BigDecimal, Version=2023.213.1010.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. A strongly-named assembly is required. (Exception from HRESULT: 0x80131044) File name: 'ExtendedNumerics.BigDecimal, Version=2023.213.1010.0, Culture=neutral, PublicKeyToken=null' at NPOI.SS.Formula.Functions.FloorCeilingMathBase.Evaluate(Double number, Double significance, Boolean mode) at NPOI.SS.Formula.Functions.FloorCeilingMathBase.Evaluate(Int32 srcRowIndex, Int32 srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) in /_/main/SS/Formula/Functions/FloorCeilingMathBase.cs:line 52 at NPOI.SS.Formula.Functions.FloorCeilingMathBase.Evaluate(ValueEval[] args, OperationEvaluationContext ec) in /_/main/SS/Formula/Functions/FloorCeilingMathBase.cs:line 36 at NPOI.SS.Formula.WorkbookEvaluator.EvaluateFormula(OperationEvaluationContext ec, Ptg[] ptgs) in /_/main/SS/Formula/WorkbookEvaluator.cs:line 697 at NPOI.SS.Formula.WorkbookEvaluator.EvaluateAny(IEvaluationCell srcCell, Int32 sheetIndex, Int32 rowIndex, Int32 columnIndex, EvaluationTracker tracker) in /_/main/SS/Formula/WorkbookEvaluator.cs:line 394 at NPOI.SS.Formula.WorkbookEvaluator.Evaluate(IEvaluationCell srcCell) in /_/main/SS/Formula/WorkbookEvaluator.cs:line 260 at NPOI.XSSF.UserModel.BaseXSSFFormulaEvaluator.EvaluateFormulaCellValue(ICell cell) in /_/ooxml/XSSF/UserModel/BaseXSSFFormulaEvaluator.cs:line 63 at NPOI.SS.Formula.BaseFormulaEvaluator.EvaluateFormulaCellEnum(ICell cell) in /_/main/SS/Formula/BaseFormulaEvaluator.cs:line 199 at NPOI.SS.Formula.BaseFormulaEvaluator.EvaluateAllFormulaCells(IWorkbook wb, IFormulaEvaluator evaluator) in /_/main/SS/Formula/BaseFormulaEvaluator.cs:line 280 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at NUnit.Framework.Internal.ExceptionHelper.Rethrow(Exception exception) at NUnit.Framework.Internal.Reflect.DynamicInvokeWithTransparentExceptions(Delegate delegate) at NUnit.Framework.Internal.ExceptionHelper.RecordException(Delegate parameterlessDelegate, String parameterName) >
IsBigDecimalAlmostInteger: testcases/main/Util/TestDoublePrecisionHelper.cs#L59
System.IO.FileLoadException : Could not load file or assembly 'ExtendedNumerics.BigDecimal, Version=2023.213.1010.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. A strongly-named assembly is required. (Exception from HRESULT: 0x80131044)
ubuntu-latest
/home/runner/work/npoi/npoi/ooxml/NPOI.OOXML.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [/home/runner/work/npoi/npoi/solution/NPOI.Core.Test.sln]
ubuntu-latest
/home/runner/work/npoi/npoi/OpenXmlFormats/NPOI.OpenXmlFormats.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [/home/runner/work/npoi/npoi/solution/NPOI.Core.Test.sln]
ubuntu-latest
/home/runner/work/npoi/npoi/main/NPOI.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [/home/runner/work/npoi/npoi/solution/NPOI.Core.Test.sln]
ubuntu-latest
/home/runner/work/npoi/npoi/solution/NPOI.Pack.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [/home/runner/work/npoi/npoi/solution/NPOI.Core.Test.sln]
ubuntu-latest
/home/runner/work/npoi/npoi/openxml4Net/NPOI.OpenXml4Net.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [/home/runner/work/npoi/npoi/solution/NPOI.Core.Test.sln]
ubuntu-latest
/home/runner/work/npoi/npoi/ooxml/NPOI.OOXML.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [TargetFramework=net472]
ubuntu-latest
/home/runner/work/npoi/npoi/main/NPOI.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [TargetFramework=net472]
ubuntu-latest
/home/runner/work/npoi/npoi/main/NPOI.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [TargetFramework=netstandard2.0]
ubuntu-latest
/home/runner/work/npoi/npoi/main/POIFS/Crypt/Standard/StandardDecryptor.cs(225,20): warning CS0114: 'CipherInputStream.Read(byte[])' hides inherited member 'InputStream.Read(byte[])'. To make the current member override that implementation, add the override keyword. Otherwise add the new keyword. [/home/runner/work/npoi/npoi/main/NPOI.Core.csproj::TargetFramework=netstandard2.0]
ubuntu-latest
/home/runner/work/npoi/npoi/main/POIFS/Crypt/Standard/StandardDecryptor.cs(262,21): warning CS0114: 'CipherInputStream.Skip(long)' hides inherited member 'InputStream.Skip(long)'. To make the current member override that implementation, add the override keyword. Otherwise add the new keyword. [/home/runner/work/npoi/npoi/main/NPOI.Core.csproj::TargetFramework=netstandard2.0]
windows-latest
D:\a\npoi\npoi\openxml4Net\NPOI.OpenXml4Net.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [D:\a\npoi\npoi\solution\NPOI.Core.Test.sln]
windows-latest
D:\a\npoi\npoi\ooxml\NPOI.OOXML.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [D:\a\npoi\npoi\solution\NPOI.Core.Test.sln]
windows-latest
D:\a\npoi\npoi\main\NPOI.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [D:\a\npoi\npoi\solution\NPOI.Core.Test.sln]
windows-latest
D:\a\npoi\npoi\solution\NPOI.Pack.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [D:\a\npoi\npoi\solution\NPOI.Core.Test.sln]
windows-latest
D:\a\npoi\npoi\OpenXmlFormats\NPOI.OpenXmlFormats.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [D:\a\npoi\npoi\solution\NPOI.Core.Test.sln]
windows-latest
D:\a\npoi\npoi\ooxml\NPOI.OOXML.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [TargetFramework=net472]
windows-latest
D:\a\npoi\npoi\main\NPOI.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [TargetFramework=net472]
windows-latest
D:\a\npoi\npoi\main\NPOI.Core.csproj : warning NU1701: Package 'ExtendedNumerics.BigDecimal 2023.213.1010' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project. [TargetFramework=netstandard2.0]
windows-latest
D:\a\npoi\npoi\main\POIFS\Crypt\Standard\StandardDecryptor.cs(225,20): warning CS0114: 'CipherInputStream.Read(byte[])' hides inherited member 'InputStream.Read(byte[])'. To make the current member override that implementation, add the override keyword. Otherwise add the new keyword. [D:\a\npoi\npoi\main\NPOI.Core.csproj::TargetFramework=net472]
windows-latest
D:\a\npoi\npoi\main\POIFS\Crypt\Standard\StandardDecryptor.cs(262,21): warning CS0114: 'CipherInputStream.Skip(long)' hides inherited member 'InputStream.Skip(long)'. To make the current member override that implementation, add the override keyword. Otherwise add the new keyword. [D:\a\npoi\npoi\main\NPOI.Core.csproj::TargetFramework=net472]