I have an exeption caused by Aspose.Words.Document.MailMerge.Execute
I tested it with multiple versions.. currently I'm using version 13.12.0.0
The exception is:
Value was either too large or too small for an Int32
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at x2a6f63b6650e76c4.xe02d79c539b6382d.x1f490eac106aee12(Table x1ec770899c98a268, String xc15bd84e01929885, Int32 x2238fe9b8f06bd9d)
at x2a6f63b6650e76c4.x393ce53fde4b6f6e.x1f490eac106aee12(Table x1ec770899c98a268, String x2998bc0b2545c5b6, String xd58ddfc523d7f291)
at x2a6f63b6650e76c4.x393ce53fde4b6f6e.x19890931227f0f56(x12e7545fad3ccc9b x0f7b23d1c393aed9, String xc15bd84e01929885, Boolean x87e8133a83e97e91, x209f3e4a2f735d1e& x9b10ace6509508c0)
at x2a6f63b6650e76c4.xd8780e89a96f3f1a.x9f7dc7131ed07aa4(String x137ffa3012d6a67d)
at x2a6f63b6650e76c4.xd8780e89a96f3f1a.x095ca45783003376()
at x2a6f63b6650e76c4.xd8780e89a96f3f1a.x1f490eac106aee12()
at x2a6f63b6650e76c4.xa4690fb61715fc9b.x335c6a74b612cfe6(x6f82c326b827643c xbf5efe8743edba7b)
at xfbd1009a0cbb9842.xedefa1db6f5ff538.x8169d349e75cbc3b()
at xfbd1009a0cbb9842.xfedf115fd9c03862.x84e437d6d3b09907(x5e36356bc92c609b x0f7b23d1c393aed9)
at xfbd1009a0cbb9842.xfedf115fd9c03862.x945dc04ac4e4f5ab(xb0b76bad05a97c8b xd3311d815ca25f02)
at xfbd1009a0cbb9842.xfedf115fd9c03862.x7b62f4210c900502(xcf417e2db4fe9ed3 xb1a1ccf3b9674a87, xcf417e2db4fe9ed3 x8f8ce337d74845ae)
at xe86f37adaccef1c3.xc5c3f438428cb03b.xdeeb682062ef79a5()
at Aspose.Words.Reporting.MailMerge.x18dfca7c5fd2402f(xa11a4c48b53f49a6 xef1769c4fe6ae4ca)
at Aspose.Words.Reporting.MailMerge.Execute(String[] fieldNames, Object[] values)
at x2a6f63b6650e76c4.xe02d79c539b6382d.x1f490eac106aee12(Table x1ec770899c98a268, String xc15bd84e01929885, Int32 x2238fe9b8f06bd9d)
at x2a6f63b6650e76c4.x393ce53fde4b6f6e.x1f490eac106aee12(Table x1ec770899c98a268, String x2998bc0b2545c5b6, String xd58ddfc523d7f291)
at x2a6f63b6650e76c4.x393ce53fde4b6f6e.x19890931227f0f56(x12e7545fad3ccc9b x0f7b23d1c393aed9, String xc15bd84e01929885, Boolean x87e8133a83e97e91, x209f3e4a2f735d1e& x9b10ace6509508c0)
at x2a6f63b6650e76c4.xd8780e89a96f3f1a.x9f7dc7131ed07aa4(String x137ffa3012d6a67d)
at x2a6f63b6650e76c4.xd8780e89a96f3f1a.x095ca45783003376()
at x2a6f63b6650e76c4.xd8780e89a96f3f1a.x1f490eac106aee12()
at x2a6f63b6650e76c4.xa4690fb61715fc9b.x335c6a74b612cfe6(x6f82c326b827643c xbf5efe8743edba7b)
at xfbd1009a0cbb9842.xedefa1db6f5ff538.x8169d349e75cbc3b()
at xfbd1009a0cbb9842.xfedf115fd9c03862.x84e437d6d3b09907(x5e36356bc92c609b x0f7b23d1c393aed9)
at xfbd1009a0cbb9842.xfedf115fd9c03862.x945dc04ac4e4f5ab(xb0b76bad05a97c8b xd3311d815ca25f02)
at xfbd1009a0cbb9842.xfedf115fd9c03862.x7b62f4210c900502(xcf417e2db4fe9ed3 xb1a1ccf3b9674a87, xcf417e2db4fe9ed3 x8f8ce337d74845ae)
at xe86f37adaccef1c3.xc5c3f438428cb03b.xdeeb682062ef79a5()
at Aspose.Words.Reporting.MailMerge.x18dfca7c5fd2402f(xa11a4c48b53f49a6 xef1769c4fe6ae4ca)
at Aspose.Words.Reporting.MailMerge.Execute(String[] fieldNames, Object[] values)
I suspect the error is caused by an IF fomula in a merge-field with no double quotes around a compare with a number, but I'm not sure.
Attached is a LINQPad sample (https://www.linqpad.net/ : C# statements with JSON values, super handy for you guys to test with the values that cause the exeption) and the Worddocument..
Can you confirm this is a bug in Aspose.Words?
Thanks!
Kind regards
Jeffrey
Hybrid SaaS