首页> 外国专利> SYSTEMS AND METHODS TO AUTOMATICALLY REPLACE CONTENT IN A RANGE OF SPREADSHEET CELLS WITH INFORMATION FROM A DATABASE

SYSTEMS AND METHODS TO AUTOMATICALLY REPLACE CONTENT IN A RANGE OF SPREADSHEET CELLS WITH INFORMATION FROM A DATABASE

机译:利用数据库信息自动替换电子表格单元格中内容的系统和方法

摘要

According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multi-dimensional data source. Some embodiments include receiving, at an analyzer module, a change indication from the spreadsheet application, the spreadsheet application being adapted to provide a user display having multiple rows and columns of cells, each cell being capable of containing a formula. It may be determined that the change indication is associated with range of multiple cells and that every cell in the range contains a formula of a pre-determined type. Based on an active cell associated with the change indication, information stored in the a multi-dimensional data source may be retrieved. Formulas in at least some of the cells in the range may then be automatically replaced in accordance with the retrieved information.
机译:根据一些实施例,提供了一种系统,方法,装置和/或计算机程序代码,以促进使用电子表格应用程序来访问存储在多维数据源中的信息。一些实施例包括在分析器模块处从电子表格应用程序接收改变指示,该电子表格应用程序适于提供具有多个单元格的行和列的用户显示,每个单元格能够包含公式。可以确定改变指示与多个单元格的范围相关联,并且该范围内的每个单元格都包含预定类型的公式。基于与改变指示相关联的活动单元,可以检索存储在多维数据源中的信息。然后可以根据检索到的信息自动替换该范围中至少一些单元格中的公式。

著录项

相似文献

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

客服邮箱:kefu@zhangqiaokeyan.com

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

  • 服务号