首页> 外国专利> System and method for displaying spreadsheet cell formulas in two dimensional mathematical notation

System and method for displaying spreadsheet cell formulas in two dimensional mathematical notation

机译:用于以二维数学符号显示电子表格单元格公式的系统和方法

摘要

The system takes a formula in single line form in spreadsheets and other programming environments and converts it into two dimensional mathematical notation (86). The conversion takes place at the level of a single line as entered in the programming environment or at the level of multiple lines by recursively substituting variables to build up a formula which has been sub-divided. Symbolic names are assigned to formulas (84) and input values used by formulas to give formulas more meaning when the formulas are being debugged. Complicated formulas that are too complex for the programming environment to handle, too difficult to maintain or extend in the programming environment, or too time-consuming for the programming environment to execute are solved in an independent module (94) capable of solving the complicated formulas and the solution is linked to the programming environment.
机译:该系统在电子表格和其他编程环境中采用单行形式的公式,并将其转换为二维数学符号(86)。通过递归替换变量以建立已细分的公式,可以在编程环境中输入的单行级别或多行级别进行转换。将符号名称分配给公式(84),并在公式调试时为公式赋予输入值,以使公式具有更多含义。在能够解决复杂公式的独立模块(94)中解决了复杂的公式,这些公式对于程序设计环境来说太复杂了,在程序环境中难以维护或扩展,或者对于程序设计环境来说太耗时解决方案与编程环境相关联。

著录项

相似文献

  • 专利
  • 外文文献
  • 中文文献
获取专利

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号