CN101809610B - 表单形式的表的自动生成和聚合 - Google Patents
表单形式的表的自动生成和聚合 Download PDFInfo
- Publication number
- CN101809610B CN101809610B CN200880109385.8A CN200880109385A CN101809610B CN 101809610 B CN101809610 B CN 101809610B CN 200880109385 A CN200880109385 A CN 200880109385A CN 101809610 B CN101809610 B CN 101809610B
- Authority
- CN
- China
- Prior art keywords
- spreadsheet table
- data
- list
- entry
- spreadsheet
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US11/863,459 | 2007-09-28 | ||
| US11/863,459 US20090089653A1 (en) | 2007-09-28 | 2007-09-28 | Auto-generation and syndication of tables as forms |
| PCT/US2008/078130 WO2009043009A2 (en) | 2007-09-28 | 2008-09-29 | Auto-generation and syndication of tables as forms |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101809610A CN101809610A (zh) | 2010-08-18 |
| CN101809610B true CN101809610B (zh) | 2014-10-29 |
Family
ID=40509792
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200880109385.8A Expired - Fee Related CN101809610B (zh) | 2007-09-28 | 2008-09-29 | 表单形式的表的自动生成和聚合 |
Country Status (6)
| Country | Link |
|---|---|
| US (1) | US20090089653A1 (enExample) |
| EP (1) | EP2206082A2 (enExample) |
| JP (1) | JP5315349B2 (enExample) |
| KR (1) | KR20100074155A (enExample) |
| CN (1) | CN101809610B (enExample) |
| WO (1) | WO2009043009A2 (enExample) |
Families Citing this family (28)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10133719B2 (en) * | 2007-09-28 | 2018-11-20 | Microsoft Technology Licensing, Llc | Spreadsheet workbook part libraries |
| US10409892B2 (en) | 2011-01-26 | 2019-09-10 | Microsoft Technology Licensing, Llc | Formatting data by example |
| US8924842B2 (en) * | 2011-02-25 | 2014-12-30 | Hewlett-Packard Development Company, L.P. | Method and system to build interactive documents |
| US8996981B2 (en) * | 2011-09-06 | 2015-03-31 | Onevizion, Inc. | Managing forms in electronic documents |
| US8892990B2 (en) * | 2012-03-07 | 2014-11-18 | Ricoh Co., Ltd. | Automatic creation of a table and query tools |
| US8792730B2 (en) * | 2012-03-07 | 2014-07-29 | Ricoh Co., Ltd. | Classification and standardization of field images associated with a field in a form |
| KR101361256B1 (ko) * | 2012-06-13 | 2014-02-12 | 에스케이씨앤씨 주식회사 | 데이터 시트에서의 데이터 검색용 gui 제공 방법 및 이를 적용한 전자기기 |
| KR101369107B1 (ko) * | 2012-06-26 | 2014-03-06 | 주식회사 엘지유플러스 | 오피스 프로그램의 인터페이스 개선 장치 및 방법 |
| US20140026041A1 (en) * | 2012-07-17 | 2014-01-23 | Microsoft Corporation | Interacting with a document as an application |
| JP6045393B2 (ja) * | 2013-02-26 | 2016-12-14 | 三菱電機株式会社 | 情報処理システム |
| KR101480427B1 (ko) * | 2013-04-25 | 2015-01-14 | 서울대학교병원 (분사무소) | 전자의무기록 시스템 기반 진료정보 기록 작성 제공 방법 및 시스템 |
| US10229101B2 (en) | 2013-06-14 | 2019-03-12 | Microsoft Technology Licensing, Llc | Smart fill |
| US9348561B2 (en) * | 2014-05-21 | 2016-05-24 | InvestCloud, Inc | Tabular format transaction editor |
| US20150347352A1 (en) * | 2014-06-02 | 2015-12-03 | Microsoft Technology Licensing, Llc | Form preview in a development environment |
| US10824799B2 (en) | 2014-06-30 | 2020-11-03 | Microsoft Technology Licensing, Llc | Summary data autofill |
| US20160026616A1 (en) * | 2014-07-28 | 2016-01-28 | Microsoft Corporation | Presenting dataset of spreadsheet in form based view |
| CN104881762A (zh) * | 2015-06-25 | 2015-09-02 | 中铁四局集团有限公司 | 一种工程量清单分解方法及系统 |
| CN105069542A (zh) * | 2015-06-25 | 2015-11-18 | 中铁四局集团有限公司 | 一种责任成本预算编制方法及系统 |
| CN104978307A (zh) * | 2015-06-25 | 2015-10-14 | 中铁四局集团有限公司 | 一种清单处理方法及装置 |
| CN105630759A (zh) * | 2015-12-28 | 2016-06-01 | 北京致远协创软件有限公司 | 一种数据引用的装置及方法 |
| US10387558B2 (en) * | 2016-02-23 | 2019-08-20 | International Business Machines Corporation | Provision of a separate input interface for user interaction with a spreadsheet |
| CN106776509A (zh) * | 2016-11-16 | 2017-05-31 | 武汉飞博科技有限公司 | 一种电子表单生成方法及装置 |
| WO2021022553A1 (en) * | 2019-08-08 | 2021-02-11 | Microsoft Technology Licensing, Llc | Spreadsheet table transformation |
| CN117057323A (zh) * | 2020-03-11 | 2023-11-14 | 珠海金山办公软件有限公司 | 一种信息录入方法及装置 |
| CN112837566A (zh) * | 2021-01-20 | 2021-05-25 | 山东师范大学 | 一种单纯形表自动更新的教学演示系统及方法 |
| CN114004196B (zh) * | 2021-12-30 | 2022-03-15 | 云账户技术(天津)有限公司 | 一种转换表单数据格式的方法及装置 |
| CN114579914A (zh) * | 2022-03-22 | 2022-06-03 | 通号智慧城市研究设计院有限公司 | 网页表单生成方法、电子设备、计算机可读存储介质 |
| US20240303441A1 (en) * | 2023-03-10 | 2024-09-12 | Microsoft Technology Licensing, Llc | Task decomposition for llm integrations with spreadsheet environments |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6691281B1 (en) * | 1999-06-15 | 2004-02-10 | Microsoft Corporation | Publishing/republishing data tables in HTML documents while maintaining formatting and functionality for restoring back the data tables |
Family Cites Families (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5247611A (en) * | 1989-09-15 | 1993-09-21 | Emtek Health Care Systems, Inc. | Spreadsheet cell having multiple data fields |
| US5367619A (en) * | 1990-04-27 | 1994-11-22 | Eaton Corporation | Electronic data entry system employing an expert system to facilitate generation of electronic data forms with complex interrelationships between fields and subforms |
| US5765005A (en) * | 1992-06-01 | 1998-06-09 | Hitachi, Ltd. | Method for preparing form |
| KR100287045B1 (ko) * | 1992-07-06 | 2001-04-16 | 존 비. 메이슨 | 객체의 명명 및 결합들 위한 방법 및 시스템 |
| US6877137B1 (en) * | 1998-04-09 | 2005-04-05 | Rose Blush Software Llc | System, method and computer program product for mediating notes and note sub-notes linked or otherwise associated with stored or networked web pages |
| US5604854A (en) * | 1994-04-22 | 1997-02-18 | Borland International, Inc. | System and methods for reformatting multi-dimensional spreadsheet information |
| FR2721728B1 (fr) * | 1994-06-28 | 1996-07-26 | Bull Sa | Procédé et dispositif de génération automatique de feuilles de calcul. |
| DE69600794T2 (de) * | 1995-02-22 | 1999-06-02 | Agust S. Madison Wis. Egilsson | Graphische entwicklungs- und verwaltungsumgebung für anwendungsprogramme |
| US6157934A (en) * | 1995-10-24 | 2000-12-05 | Ultimus, L.L.C. | Method and apparatus for using distributed spreadsheets in a client/server architecture for workflow automation |
| US5819293A (en) * | 1996-06-06 | 1998-10-06 | Microsoft Corporation | Automatic Spreadsheet forms |
| US7418672B2 (en) * | 2000-12-21 | 2008-08-26 | Exaflop Llc | Integrated content guide for interactive selection of content and services on personal computer systems with multiple sources and multiple media presentation |
| US6631497B1 (en) * | 1999-07-19 | 2003-10-07 | International Business Machines Corporation | Binding data from data source to cells in a spreadsheet |
| US6589290B1 (en) * | 1999-10-29 | 2003-07-08 | America Online, Inc. | Method and apparatus for populating a form with data |
| EP1109114A1 (en) * | 1999-12-14 | 2001-06-20 | Sun Microsystems, Inc. | Compound view onto data of a database |
| AU2001277868A1 (en) * | 2000-07-11 | 2002-01-21 | Juice Software, Inc. | A method and system for integrating network-based functionality into productivity applications and documents |
| JP3969943B2 (ja) * | 2000-09-20 | 2007-09-05 | 富士通株式会社 | コンピュータ・システム及び表示情報生成方法 |
| US6973618B2 (en) * | 2000-12-29 | 2005-12-06 | International Business Machines Corporation | Method and system for importing MS office forms |
| JP2002342695A (ja) * | 2001-05-17 | 2002-11-29 | Nec Corp | 情報入力システムの構築支援装置および構築支援方法 |
| US20030146937A1 (en) * | 2001-09-11 | 2003-08-07 | Lee Seung Woo | Multi-level data management system |
| US20040039990A1 (en) * | 2002-03-30 | 2004-02-26 | Xorbix Technologies, Inc. | Automated form and data analysis tool |
| US20030212640A1 (en) * | 2002-05-01 | 2003-11-13 | Hans Magnus Andresen | Universal product attribute modeler |
| JP2004280705A (ja) * | 2003-03-18 | 2004-10-07 | Mitsubishi Electric Corp | 帳票作成装置 |
| US20050097197A1 (en) * | 2003-10-07 | 2005-05-05 | International Business Machines Corporation | Web browser control for customer support |
| US7444584B1 (en) * | 2004-03-30 | 2008-10-28 | Microsoft Corporation | Method and system for formulaically redirecting and modifying formula set operations in a spreadsheet application |
| JP4509671B2 (ja) * | 2004-06-30 | 2010-07-21 | 宝印刷株式会社 | 文書編集方法及び文書編集システム |
| US7519573B2 (en) * | 2004-08-23 | 2009-04-14 | Fuji Xerox Co., Ltd. | System and method for clipping, repurposing, and augmenting document content |
| US8745483B2 (en) * | 2004-10-07 | 2014-06-03 | International Business Machines Corporation | Methods, systems and computer program products for facilitating visualization of interrelationships in a spreadsheet |
| US7818672B2 (en) * | 2004-12-30 | 2010-10-19 | Microsoft Corporation | Floating action buttons |
| US7827478B2 (en) * | 2005-09-08 | 2010-11-02 | William Farr | Dynamic generation of form pages for accessing a database |
-
2007
- 2007-09-28 US US11/863,459 patent/US20090089653A1/en not_active Abandoned
-
2008
- 2008-09-29 JP JP2010527239A patent/JP5315349B2/ja not_active Expired - Fee Related
- 2008-09-29 KR KR1020107006261A patent/KR20100074155A/ko not_active Ceased
- 2008-09-29 EP EP08834394A patent/EP2206082A2/en not_active Withdrawn
- 2008-09-29 WO PCT/US2008/078130 patent/WO2009043009A2/en not_active Ceased
- 2008-09-29 CN CN200880109385.8A patent/CN101809610B/zh not_active Expired - Fee Related
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6691281B1 (en) * | 1999-06-15 | 2004-02-10 | Microsoft Corporation | Publishing/republishing data tables in HTML documents while maintaining formatting and functionality for restoring back the data tables |
Also Published As
| Publication number | Publication date |
|---|---|
| US20090089653A1 (en) | 2009-04-02 |
| JP5315349B2 (ja) | 2013-10-16 |
| KR20100074155A (ko) | 2010-07-01 |
| JP2010541081A (ja) | 2010-12-24 |
| EP2206082A2 (en) | 2010-07-14 |
| CN101809610A (zh) | 2010-08-18 |
| WO2009043009A2 (en) | 2009-04-02 |
| WO2009043009A3 (en) | 2009-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101809610B (zh) | 表单形式的表的自动生成和聚合 | |
| US10713427B2 (en) | Systems and methods for providing a communication program interface with an integrated tabular data management interface | |
| US10698589B1 (en) | Data visualization user interface for simplified custom calculations | |
| CN102870106B (zh) | 所选择的数据的临时格式化和绘制 | |
| US9176933B2 (en) | Application of multiple content items and functionality to an electronic content item | |
| US9286271B2 (en) | Providing an electronic document collection | |
| US6985902B2 (en) | Method, system and apparatus for creating and accessing a hierarchical database in a format optimally suited to real estate listings | |
| CA2807201C (en) | System for and method of collaborative annotation of digital content | |
| US8171390B1 (en) | Method and system for viewing and transferring data between documents | |
| KR101298415B1 (ko) | 이종 정보 시스템의 데이터를 사용하여 협업애플리케이션의 문서에 주석을 삽입하는 방법 | |
| US20090199082A1 (en) | System and method for annotation of web pages | |
| US20100083173A1 (en) | Method and system for applying metadata to data sets of file objects | |
| US20150142858A1 (en) | Identifying and formatting data for data migration | |
| JP5456322B2 (ja) | オペレーティングシステムユーザインターフェースを使用して文書および文書オブジェクトにメタデータを付加する方法 | |
| US8832645B2 (en) | Quick-creating objects in an application | |
| US20240111944A1 (en) | System and Method for Annotation-Based Document Management | |
| US8091016B2 (en) | Visually manipulating instance collections | |
| US7231598B1 (en) | User interface for editing documents containing markup language | |
| US9069812B1 (en) | Method and apparatus for assembling a business document | |
| Cornell | Excel as your database | |
| Murray | First Look 2007 Microsoft Office System | |
| AU2016247171B2 (en) | System for and method of collaborative annotation of digital content | |
| CN110489377A (zh) | 一种基于标签的信息管理系统、方法、存储器及电子设备 | |
| Nelson | Meet the multidimensional worksheet. |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: MICROSOFT TECHNOLOGY LICENSING LLC Free format text: FORMER OWNER: MICROSOFT CORP. Effective date: 20150421 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20150421 Address after: Washington State Patentee after: Micro soft technique license Co., Ltd Address before: Washington State Patentee before: Microsoft Corp. |
|
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20141029 Termination date: 20150929 |
|
| EXPY | Termination of patent right or utility model |