[10.0.102]发布出错

登录

本帖最后由罗耀斌于 2024-12-18 12:46 编辑

【=IF(CJ11=AJ11,0,IF(CJ11<>AJ11,IF(CJ11>0,2,IF(CJ11=0,1,"其他情况"))))】
同事加了公式，工具直接发布不了了，公式数据类型问题没考虑到是有问题但已经去掉了，但还是发布不了

## Overview
- Version: 10.0.102.0
- Exception: `Newtonsoft.Json.JsonSerializationException`
- DateTime: 2024/12/6 10:30:28
- Email: 527124979@qq.com
- Tags: #CN, #COLLABORATION

## Exception
```json
{
  "ClassName": "Newtonsoft.Json.JsonSerializationException",
  "Message": "Error getting value from 'Row' on 'Forguncy.Common.FormulaCellLocation'.",
  "Data": {
"$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib",
"System.Object": null
  },
  "InnerException": {
"$type": "GrapeCity.CalcEngine.CalcParseException, GrapeCity.WPF.CalcEngine",
"Message": "Invalid cell reference or name.
Error offset:0",
"ErrorOffset": 0,
"Data": {
   "$type": "System.Collections.ListDictionaryInternal, System.Private.CoreLib"
},
"InnerException": null,
"HelpLink": null,
"Source": "GrapeCity.WPF.CalcEngine",
"HResult": -2146233088,
"StackTrace": " at GrapeCity.CalcEngine.CalcParser.BuildCellReferenceOrNameExpressions(CalcParserContext context, String value, Int32 index)
at GrapeCity.CalcEngine.CalcParser.BuildExpressionNode(CalcParserContext context, FormulaToken token)
at GrapeCity.CalcEngine.CalcParser.PaseToBinaryOperatorList(CalcParserContext context, List`1 tokens)
at GrapeCity.CalcEngine.CalcParser.BuildExpressionTree(CalcParserContext context, List`1 tokens)
at jx.GetCellExpress(FormulaReferObject formulaReferObject)
at Forguncy.Common.FormulaCellLocation.GetCellExpress()
at Forguncy.Common.FormulaCellLocation.get_Row()
at lambda_method6702(Closure , Object )
at Newtonsoft.Json.Serialization.ExpressionValueProvider.GetValue(Object target)"
  },
  "HelpURL": null,
  "StackTraceString": " at Newtonsoft.Json.Serialization.ExpressionValueProvider.GetValue(Object target)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.CalculatePropertyValues(JsonWriter writer, Object value, JsonContainerContract contract, JsonProperty member, JsonProperty property, JsonContract& memberContract, Object& memberValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeList(JsonWriter writer, IEnumerable values, JsonArrayContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeList(JsonWriter writer, IEnumerable values, JsonArrayContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeList(JsonWriter writer, IEnumerable values, JsonArrayContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeList(JsonWriter writer, IEnumerable values, JsonArrayContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeList(JsonWriter writer, IEnumerable values, JsonArrayContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.Serialize(JsonWriter jsonWriter, Object value, Type objectType)
at Newtonsoft.Json.JsonSerializer.SerializeInternal(JsonWriter jsonWriter, Object value, Type objectType)
at Newtonsoft.Json.JsonConvert.SerializeObjectInternal(Object value, Type type, JsonSerializer jsonSerializer)
at my.c.cme()
at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
at my.clj(Worksheet a, mx b, Int32 c)
at my.clc(PublishType a, TaskInfo b, PublishSettingsViewModel c)
at my.GenerateAllPagesAsync(PublishType publishType, TaskInfo taskInfo, PublishSettingsViewModel settings)
at my.GenerateAllPagesAsync(PublishType publishType, TaskInfo taskInfo, PublishSettingsViewModel settings)
at Forguncy.Views.RibbonView.BrowserHomeExecutedWithProgressbarAsync(IBrowser browser, TaskInfo taskInfo, Boolean debug)
at Forguncy.Views.RibbonView.<>c__DisplayClass402_0.<<BrowserHomeExecutedWithProgressbarAsync>b__0>d.MoveNext()
--- End of stack trace from previous location ---
at WPFBase.Common.TaskInfoHelper.CreateAThreadCrossedAutoClosedWindowAsync(TaskInfo taskInfo, Window owner, Func`1 action)
at Forguncy.Views.RibbonView.BrowserHomeExecutedWithProgressbarAsync(IBrowser browser, TaskInfo taskInfo, Boolean debug)
at Forguncy.Views.RibbonView.BrowserHome_Click(Object sender, RoutedEventArgs routedEventArgs)
at System.Threading.Tasks.Task.<>c.<ThrowAsync>b__128_0(Object state)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)",
  "RemoteStackTraceString": null,
  "RemoteStackIndex": 0,
  "ExceptionMethod": null,
  "HResult": -2146233088,
  "Source": "Newtonsoft.Json",
  "WatsonBuckets": null
}
```

## EventLog
- 10:30:23 `MouseL`:Window:cloud-stock-system-master - 活字格 (10.0.102.0)->RibbonView->RibbonGroupBox:在浏览器中打开->ToggleButton:开始->Image:/Start_32.png
- 10:30:09 `MouseL`:Window:打开协作工程->Button:确定
- 10:30:09 `KeyDown`:Control+V
- 10:30:09 `MouseL`:Window:打开协作工程->TextBox:
- 10:30:08 `MouseL`:Window:活字格 (10.0.102.0)->打开协作工程

## ActionList