-
公开(公告)号:US07533340B2
公开(公告)日:2009-05-12
申请号:US10962361
申请日:2004-10-08
申请人: Margaret G. Hudson , Tuan Huynh , Kent R. Lowry , Justin M. Maguire, III , Eric W. Patterson , Marcella Rader , Mariya Tikunova
发明人: Margaret G. Hudson , Tuan Huynh , Kent R. Lowry , Justin M. Maguire, III , Eric W. Patterson , Marcella Rader , Mariya Tikunova
IPC分类号: G06F3/048
CPC分类号: G06F17/246 , G06F9/453
摘要: An interactive tooltip provides access to help information and enhanced editing capabilities. The interactive tooltip may be useful for a user editing a function within a spreadsheet formula. The present invention may integrate HTML-like interactivity with a conventional tooltip to provide a new interface for working with the associated data. The interactivity of the tooltip may provide additional levels of help or documentation when requested and may provides additional editing navigation functionality within the associated data. Embodiments of the present invention may provide a tooltip in close proximity to the associated data, while the associated data is being edited. In the case of a spreadsheet, a tooltip may be provided when the user begins editing a function within a spreadsheet cell. The help facility may recognize that the user has begun entering a function.
摘要翻译: 交互式工具提示可以访问帮助信息和增强的编辑功能。 交互式工具提示可能对用户编辑电子表格公式中的函数很有用。 本发明可以将HTML类交互性与常规工具提示集成,以提供用于处理相关数据的新界面。 工具提示的交互性可以在请求时提供额外的帮助或文档级别,并可能在相关数据中提供附加的编辑导航功能。 本发明的实施例可以提供紧密相关联的数据的工具提示,同时正在对相关联的数据进行编辑。 在电子表格的情况下,当用户开始编辑电子表格单元格内的功能时,可以提供工具提示。 帮助设施可以识别用户已经开始输入功能。
-
公开(公告)号:US06828988B2
公开(公告)日:2004-12-07
申请号:US09794691
申请日:2001-02-27
申请人: Margaret G. Hudson , Tuan Huynh , Kent R Lowry , Justin M. Maguire, III , Eric W. Patterson , Marcella Rader , Mariya Tikunova
发明人: Margaret G. Hudson , Tuan Huynh , Kent R Lowry , Justin M. Maguire, III , Eric W. Patterson , Marcella Rader , Mariya Tikunova
IPC分类号: G06F314
CPC分类号: G06F17/246 , G06F9/453
摘要: An interactive tooltip provides access to help information and enhanced editing capabilities. The interactive tooltip is especially useful for a user editing a function within a spreadsheet formula. The present invention integrates HTML-like interactivity with a conventional tooltip to provide a new interface for working with the associated data. The interactivity of the tooltip provides additional levels of help or documentation when requested and provides additional editing navigation functionality within the associated data. The present invention provides a tooltip in close proximity to the associated data, while the associated data is being edited. In the case of a spreadsheet, a tooltip will be provided when the user begins editing a function within a spreadsheet cell. The help facility of the present invention recognizes that the user has begun entering a function, when the user has entered an equals sign (identifying a formula), a known function name, and a parenthesis (indicating the beginning of an argument set). The help facility then references a function database and determines the required argument set. The help facility renders the function name and argument set in an HTML-like text, and provides an alternate method for selecting any argument. Finally, the help facility displays the HTML-like text to the user next to the point at which the user is editing the spreadsheet function.
摘要翻译: 交互式工具提示可以访问帮助信息和增强的编辑功能。 交互式工具提示对于用户在电子表格公式中编辑函数特别有用。 本发明将HTML类交互性与常规工具提示集成,以提供用于处理相关数据的新界面。 工具提示的交互性在请求时提供额外的帮助或文档级别,并在相关数据中提供附加的编辑导航功能。 本发明提供了一个紧密关联数据的工具提示,同时正在对相关数据进行编辑。 在电子表格的情况下,当用户开始编辑电子表格单元格内的函数时,将提供工具提示。 本发明的帮助设施认识到,当用户已经输入等号(识别公式),已知功能名称和括号(指示参数集的开始)时,用户已经开始输入功能。 然后,帮助工具引用函数数据库并确定所需的参数集。 帮助功能将函数名称和参数设置为类似HTML的文本,并为选择任何参数提供了一种替代方法。 最后,帮助工具在用户正在编辑电子表格功能的点旁边向用户显示类似HTML的文本。
-
公开(公告)号:US20050050470A1
公开(公告)日:2005-03-03
申请号:US10962361
申请日:2004-10-08
申请人: Margaret Hudson , Tuan Huynh , Kent Lowry , Justin Maguire , Eric Patterson , Marcella Rader , Mariya Tikunova
发明人: Margaret Hudson , Tuan Huynh , Kent Lowry , Justin Maguire , Eric Patterson , Marcella Rader , Mariya Tikunova
CPC分类号: G06F17/246 , G06F9/453
摘要: An interactive tooltip provides access to help information and enhanced editing capabilities. The interactive tooltip is especially useful for a user editing a function within a spreadsheet formula. The present invention integrates HTML-like interactivity with a conventional tooltip to provide a new interface for working with the associated data. The interactivity of the tooltip provides additional levels of help or documentation when requested and provides additional editing navigation functionality within the associated data. The present invention provides a tooltip in close proximity to the associated data, while the associated data is being edited. In the case of a spreadsheet, a tooltip will be provided when the user begins editing a function within a spreadsheet cell. The help facility of the present invention recognizes that the user has begun entering a function, when the user has entered an equals sign (identifying a formula), a known function name, and a parenthesis (indicating the beginning of an argument set). The help facility then references a function database and determines the required argument set. The help facility renders the function name and argument set in an HTML-like text, and provides an alternate method for selecting any argument. Finally, the help facility displays the HTML-like text to the user next to the point at which the user is editing the spreadsheet function.
摘要翻译: 交互式工具提示可以访问帮助信息和增强的编辑功能。 交互式工具提示对于用户在电子表格公式中编辑函数特别有用。 本发明将HTML类交互性与常规工具提示集成,以提供用于处理相关数据的新界面。 工具提示的交互性在请求时提供额外的帮助或文档级别,并在相关数据中提供附加的编辑导航功能。 本发明提供了一个紧密关联数据的工具提示,同时正在对相关数据进行编辑。 在电子表格的情况下,当用户开始编辑电子表格单元格内的函数时,将提供工具提示。 本发明的帮助设施认识到,当用户已经输入等号(识别公式),已知功能名称和括号(指示参数集的开始)时,用户已经开始输入功能。 然后,帮助工具引用函数数据库并确定所需的参数集。 帮助功能将函数名称和参数设置为类似HTML的文本,并为选择任何参数提供了一种替代方法。 最后,帮助工具在用户正在编辑电子表格功能的点旁边向用户显示类似HTML的文本。
-
公开(公告)号:US07117430B2
公开(公告)日:2006-10-03
申请号:US09794595
申请日:2001-02-27
IPC分类号: G06F15/00
CPC分类号: G06F17/246
摘要: An error checker identifies spreadsheet errors by traversing a spreadsheet cell-by-cell and comparing each cell's contents to a list of error rules. When a cell's contents satisfy an error rules, then the cell is identified as containing a potential spreadsheet error. The error checker identifies potential spreadsheet errors and marks the cells containing the potential errors with an error indicator. A drop-down menu is provided that includes an element identifying the error rule that was invoked by the cell's contents and may include one or more recommended actions to resolve the identified error.
摘要翻译: 错误检查器通过逐个遍历电子表格并将每个单元格的内容与错误规则列表进行比较来识别电子表格错误。 当单元格的内容满足错误规则时,单元格被识别为包含潜在的电子表格错误。 错误检查器识别潜在的电子表格错误,并使用错误指示器标记包含潜在错误的单元格。 提供了一个下拉菜单,其中包含一个元素,标识由单元格内容调用的错误规则,并可能包含一个或多个推荐的操作来解决已识别的错误。
-
公开(公告)号:US20050097115A1
公开(公告)日:2005-05-05
申请号:US11007008
申请日:2004-12-08
申请人: Jesse Bedford , Matthew Gauthier , Tuan Huynh , Ramakrishnan NataraJan , Justin Maguire , Marcella Rader
发明人: Jesse Bedford , Matthew Gauthier , Tuan Huynh , Ramakrishnan NataraJan , Justin Maguire , Marcella Rader
CPC分类号: G06F17/246 , Y10S707/99942 , Y10S707/99943
摘要: The invention, in one embodiment, is a method and system for reporting the status of external references, or links, of a spreadsheet workbook. In an Edit Links dialog box, the user may view a list of links and their status. The user may select a Check Status button in the Edit Links dialog box to check the status of the links without updating the links because updating the links may require considerable time. A textual status message is displayed for each link in the Edit Links dialog box. The textual status message indicates to the user whether there is s possible problem with the link. As part of checking the status of a link, an analysis is made to determine whether any problems with the source file exist. For instance, it is determined whether the source file is open and whether it is valid. The results of this analysis determine what is displayed in the status column of the Edit Links dialog box.
-
公开(公告)号:US20050108623A1
公开(公告)日:2005-05-19
申请号:US11006980
申请日:2004-12-08
申请人: Jesse Bedford , Matthew Gauthier , Tuan Huynh , Ramakrishnan NataraJan , Justin Maguire , Marcella Rader
发明人: Jesse Bedford , Matthew Gauthier , Tuan Huynh , Ramakrishnan NataraJan , Justin Maguire , Marcella Rader
CPC分类号: G06F17/246 , Y10S707/99942 , Y10S707/99943
摘要: The invention, in one embodiment, is a method and system for reporting the status of external references, or links, of a spreadsheet workbook. In an Edit Links dialog box, the user may view a list of links and their status. The user may select a Check Status button in the Edit Links dialog box to check the status of the links without updating the links because updating the links may require considerable time. A textual status message is displayed for each link in the Edit Links dialog box. The textual status message indicates to the user whether there is s possible problem with the link. As part of checking the status of a link, an analysis is made to determine whether any problems with the source file exist. For instance, it is determined whether the source file is open and whether it is valid. The results of this analysis determine what is displayed in the status column of the Edit Links dialog box.
-
-
-
-
-