CN102982016A - 用于电子表格应用程序的快速分析工具 - Google Patents

用于电子表格应用程序的快速分析工具 Download PDF

Info

Publication number
CN102982016A
CN102982016A CN2012105146000A CN201210514600A CN102982016A CN 102982016 A CN102982016 A CN 102982016A CN 2012105146000 A CN2012105146000 A CN 2012105146000A CN 201210514600 A CN201210514600 A CN 201210514600A CN 102982016 A CN102982016 A CN 102982016A
Authority
CN
China
Prior art keywords
data
analysis tool
rapid analysis
cell
computer
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.)
Pending
Application number
CN2012105146000A
Other languages
English (en)
Chinese (zh)
Inventor
C·B·罗斯切里尔
T·S·康斯坦丁
A·J·贝克
D·陈
G·贝瑞
潘晓辉
I·B·佩耶夫
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Technology Licensing LLC
Original Assignee
Microsoft Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Microsoft Corp filed Critical Microsoft Corp
Publication of CN102982016A publication Critical patent/CN102982016A/zh
Pending legal-status Critical Current

Links

Images

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

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)
  • Document Processing Apparatus (AREA)
CN2012105146000A 2011-12-05 2012-12-04 用于电子表格应用程序的快速分析工具 Pending CN102982016A (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US13/311,541 US20130145244A1 (en) 2011-12-05 2011-12-05 Quick analysis tool for spreadsheet application programs
US13/311,541 2011-12-05

Publications (1)

Publication Number Publication Date
CN102982016A true CN102982016A (zh) 2013-03-20

Family

ID=47856057

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2012105146000A Pending CN102982016A (zh) 2011-12-05 2012-12-04 用于电子表格应用程序的快速分析工具

Country Status (12)

Country Link
US (1) US20130145244A1 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
EP (1) EP2788852A4 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
JP (1) JP2015507779A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
KR (1) KR20140105733A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
CN (1) CN102982016A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
AU (1) AU2012348174A1 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
BR (1) BR112014013454A8 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
CA (1) CA2857409A1 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
IN (1) IN2014CN03963A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
MX (1) MX2014006732A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
RU (1) RU2014122851A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)
WO (1) WO2013085727A1 (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103544250A (zh) * 2013-10-11 2014-01-29 华为技术有限公司 一种数据分析方法及装置
CN103699387A (zh) * 2013-12-27 2014-04-02 金蝶软件（中国）有限公司 表格处理方法和系统
CN104732418A (zh) * 2014-12-11 2015-06-24 科技先知有限公司 积分交易的系统及其方法
CN105378705A (zh) * 2013-06-14 2016-03-02 微软技术许可有限责任公司 智能选择引擎
CN107257968A (zh) * 2015-02-27 2017-10-17 微软技术许可有限责任公司 发现电子表格中的独特公式集
CN109858000A (zh) * 2019-01-10 2019-06-07 广州视源电子科技股份有限公司 表格处理方法、装置、系统、存储介质及交互智能平板
CN110874644A (zh) * 2019-11-13 2020-03-10 第四范式（北京）技术有限公司 辅助用户探索数据集、数据表的方法及装置
CN119045690A (zh) * 2024-10-31 2024-11-29 一网互通(北京)科技有限公司 前端提示组件显示优化的实现方法及装置

Families Citing this family (68)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120159395A1 (en) 2010-12-20 2012-06-21 Microsoft Corporation Application-launching interface for multiple modes
US8612874B2 (en) 2010-12-23 2013-12-17 Microsoft Corporation Presenting an application change through a tile
US8689123B2 (en) 2010-12-23 2014-04-01 Microsoft Corporation Application reporting in an application-selectable user interface
US9104307B2 (en) 2011-05-27 2015-08-11 Microsoft Technology Licensing, Llc Multi-application environment
US8893033B2 (en) 2011-05-27 2014-11-18 Microsoft Corporation Application notifications
US9202297B1 (en) * 2011-07-12 2015-12-01 Domo, Inc. Dynamic expansion of data visualizations
US10001898B1 (en) 2011-07-12 2018-06-19 Domo, Inc. Automated provisioning of relational information for a summary data visualization
US9792017B1 (en) 2011-07-12 2017-10-17 Domo, Inc. Automatic creation of drill paths
US20130057587A1 (en) 2011-09-01 2013-03-07 Microsoft Corporation Arranging tiles
US9146670B2 (en) 2011-09-10 2015-09-29 Microsoft Technology Licensing, Llc Progressively indicating new content in an application-selectable user interface
US9135233B2 (en) 2011-10-13 2015-09-15 Microsoft Technology Licensing, Llc Suggesting alternate data mappings for charts
US9588953B2 (en) 2011-10-25 2017-03-07 Microsoft Technology Licensing, Llc Drag and drop always sum formulas
US10061473B2 (en) 2011-11-10 2018-08-28 Microsoft Technology Licensing, Llc Providing contextual on-object control launchers and controls
US8793567B2 (en) 2011-11-16 2014-07-29 Microsoft Corporation Automated suggested summarizations of data
US9224217B2 (en) * 2012-01-06 2015-12-29 Apple Inc. Analytical charting
US9501219B2 (en) * 2012-01-25 2016-11-22 Oracle International Corporation 2D line data cursor
JP2014010801A (ja) * 2012-07-03 2014-01-20 Casio Comput Co Ltd ヒストグラム表示装置およびプログラム
US9164673B2 (en) * 2012-07-16 2015-10-20 Microsoft Technology Licensing, Llc Location-dependent drag and drop UI
US9658746B2 (en) * 2012-07-20 2017-05-23 Nook Digital, Llc Accessible reading mode techniques for electronic devices
WO2014027999A1 (en) * 2012-08-14 2014-02-20 Empire Technology Development Llc Dynamic content preview
KR101407329B1 (ko) * 2012-11-16 2014-06-16 선문대학교 산학협력단 터치 화면을 구비하는 디스플레이 장치 및 그의 화면 제어 방법
US9158766B2 (en) * 2012-11-29 2015-10-13 Oracle International Corporation Multi-touch interface for visual analytics
CA2838165A1 (en) * 2012-12-31 2014-06-30 Smart Technologies Ulc Method for manipulating tables on an interactive input system and interactive input system executing the method
US20140214804A1 (en) * 2013-01-31 2014-07-31 Business Objects Software Ltd. Methods, apparatus and system for a multi-resolution visual crosstab
US20140245195A1 (en) * 2013-02-25 2014-08-28 International Business Machines Corporation Duplicating graphical widgets
US10134009B2 (en) * 2013-03-13 2018-11-20 Sap Se Methods and systems of providing supplemental informaton
US10360297B2 (en) * 2013-06-14 2019-07-23 Microsoft Technology Licensing, Llc Simplified data input in electronic documents
US20150088925A1 (en) * 2013-09-20 2015-03-26 Oracle International Corporation User interface for pivot views
US20150169531A1 (en) * 2013-12-17 2015-06-18 Microsoft Corporation Touch/Gesture-Enabled Interaction with Electronic Spreadsheets
US8862646B1 (en) 2014-03-25 2014-10-14 PlusAmp, Inc. Data file discovery, visualization, and importing
CN105359094A (zh) 2014-04-04 2016-02-24 微软技术许可有限责任公司 可扩展应用表示
KR102107275B1 (ko) 2014-04-10 2020-05-06 마이크로소프트 테크놀로지 라이센싱, 엘엘씨 컴퓨팅 디바이스에 대한 접이식 쉘 커버
KR20160143784A (ko) 2014-04-10 2016-12-14 마이크로소프트 테크놀로지 라이센싱, 엘엘씨 컴퓨팅 디바이스용 슬라이더 커버
US20150356061A1 (en) * 2014-06-06 2015-12-10 Microsoft Corporation Summary view suggestion based on user interaction pattern
US10824799B2 (en) * 2014-06-30 2020-11-03 Microsoft Technology Licensing, Llc Summary data autofill
US10606855B2 (en) * 2014-07-10 2020-03-31 Oracle International Corporation Embedding analytics within transaction search
US10585892B2 (en) 2014-07-10 2020-03-10 Oracle International Corporation Hierarchical dimension analysis in multi-dimensional pivot grids
KR102399588B1 (ko) 2014-09-17 2022-05-19 삼성전자주식회사 애플리케이션 디스플레이 디바이스 및 방법
US20160110321A1 (en) * 2014-10-17 2016-04-21 Karol Kalisz Application customization through linked embedded areas
CN106662891B (zh) 2014-10-30 2019-10-11 微软技术许可有限责任公司 多配置输入设备
US9904456B2 (en) * 2014-12-02 2018-02-27 Business Objects Software Ltd. Gesture-based visualization of data grid on mobile device
US9910843B2 (en) 2015-02-03 2018-03-06 Intuit Inc. Systems, methods and articles for a web-based spreadsheet application
US20160253308A1 (en) * 2015-02-27 2016-09-01 Microsoft Technology Licensing, Llc Analysis view for pivot table interfacing
US10290147B2 (en) 2015-08-11 2019-05-14 Microsoft Technology Licensing, Llc Using perspective to visualize data
US10331899B2 (en) 2015-10-24 2019-06-25 Oracle International Corporation Display of dynamic contextual pivot grid analytics
US9836444B2 (en) 2015-12-10 2017-12-05 International Business Machines Corporation Spread cell value visualization
US10466867B2 (en) 2016-04-27 2019-11-05 Coda Project, Inc. Formulas
US10824803B2 (en) 2016-09-12 2020-11-03 DataRails LTD. System and method for logical identification of differences between spreadsheets
US11093703B2 (en) * 2016-09-29 2021-08-17 Google Llc Generating charts from data in a data table
US10216494B2 (en) 2016-12-03 2019-02-26 Thomas STACHURA Spreadsheet-based software application development
US10540153B2 (en) 2016-12-03 2020-01-21 Thomas STACHURA Spreadsheet-based software application development
US11726753B2 (en) 2016-12-03 2023-08-15 Thomas STACHURA Spreadsheet-based software application development
US11170164B2 (en) 2016-12-11 2021-11-09 DataRails LTD. System and method for cell comparison between spreadsheets
US11080475B2 (en) * 2017-01-17 2021-08-03 Microsoft Technology Licensing, Llc Predicting spreadsheet properties
US10956237B2 (en) * 2017-06-02 2021-03-23 Oracle International Corporation Inter-application sharing of business intelligence data
CA3216654A1 (en) * 2017-12-03 2019-06-06 Thomas Stachura Spreadsheet-based software application development
US10860656B2 (en) * 2017-12-05 2020-12-08 Microsoft Technology Licensing, Llc Modular data insight handling for user application data
US10996835B1 (en) * 2018-12-14 2021-05-04 Tableau Software, Inc. Data preparation user interface with coordinated pivots
US11694023B2 (en) 2020-07-13 2023-07-04 Adaptam Inc. Method and system for improved spreadsheet analytical functioning
US11972204B2 (en) * 2020-07-13 2024-04-30 Adaptam Inc. Method and system for improved ordering of output from spreadsheet analytical functions
CN112087325B (zh) * 2020-08-21 2021-07-20 烽火通信科技股份有限公司 灰度发布方法、装置、设备及可读存储介质
WO2022182796A1 (en) 2021-02-23 2022-09-01 Coda Project, Inc. System, method, and apparatus for publication and external interfacing for a unified document surface
US12050859B2 (en) 2021-09-03 2024-07-30 Adaptam Inc. Method and system for improved 2D ordering of output from spreadsheet analytical functions
US11900133B2 (en) * 2021-12-01 2024-02-13 Microsoft Technology Licensing, Llc Discovery and suggestions for unstructured tables in spreadsheets
US11755829B1 (en) * 2022-07-06 2023-09-12 Microsoft Technology Licensing, Llc Enhanced spreadsheet presentation using spotlighting and enhanced spreadsheet collaboration using live typing
US12387397B2 (en) 2022-11-03 2025-08-12 Adobe Inc. Automatically generating axes for data visualizations including data bound objects
US20240153169A1 (en) * 2022-11-03 2024-05-09 Adobe Inc. Changing coordinate systems for data bound objects
CN118095248A (zh) * 2022-11-22 2024-05-28 普奇科技有限公司 电子装置及非瞬时计算机可读存储介质

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5844572A (en) * 1995-06-07 1998-12-01 Binaryblitz Method and apparatus for data alteration by manipulation of representational graphs
JP2004028864A (ja) * 2002-06-27 2004-01-29 Shimadzu Corp 分析装置のデータ処理装置
CN1755599A (zh) * 2004-09-27 2006-04-05 微软公司 软件程序的一次点击条件格式化方法和系统
CN1790325A (zh) * 2004-12-15 2006-06-21 微软公司 按照格式过滤和分类
US7127672B1 (en) * 2003-08-22 2006-10-24 Microsoft Corporation Creating and managing structured data in an electronic spreadsheet
CN101253494A (zh) * 2005-08-30 2008-08-27 微软公司 可定制电子表格样式
US7882427B2 (en) * 2003-07-24 2011-02-01 Balenz Software, Inc. System and method for managing a spreadsheet
US20110087954A1 (en) * 2009-10-09 2011-04-14 Microsoft Corporation Data analysis expressions

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5040131A (en) * 1987-12-23 1991-08-13 International Business Machines Corporation Graphical processing
US5375201A (en) * 1992-12-18 1994-12-20 Borland International, Inc. System and methods for intelligent analytical graphing
US20060074879A1 (en) * 2004-09-30 2006-04-06 Microsoft Corporation Easy-to-use data context filtering
US8132106B2 (en) * 2006-06-23 2012-03-06 Microsoft Corporation Providing a document preview
JP2010218048A (ja) * 2009-03-13 2010-09-30 Nec Corp 情報処理装置、ガントチャートデータ再構成方法及びプログラム

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5844572A (en) * 1995-06-07 1998-12-01 Binaryblitz Method and apparatus for data alteration by manipulation of representational graphs
JP2004028864A (ja) * 2002-06-27 2004-01-29 Shimadzu Corp 分析装置のデータ処理装置
US7882427B2 (en) * 2003-07-24 2011-02-01 Balenz Software, Inc. System and method for managing a spreadsheet
US7127672B1 (en) * 2003-08-22 2006-10-24 Microsoft Corporation Creating and managing structured data in an electronic spreadsheet
CN1755599A (zh) * 2004-09-27 2006-04-05 微软公司 软件程序的一次点击条件格式化方法和系统
CN1790325A (zh) * 2004-12-15 2006-06-21 微软公司 按照格式过滤和分类
CN101253494A (zh) * 2005-08-30 2008-08-27 微软公司 可定制电子表格样式
US20110087954A1 (en) * 2009-10-09 2011-04-14 Microsoft Corporation Data analysis expressions

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105378705A (zh) * 2013-06-14 2016-03-02 微软技术许可有限责任公司 智能选择引擎
CN105378705B (zh) * 2013-06-14 2018-10-26 微软技术许可有限责任公司 智能选择引擎
US10198423B2 (en) 2013-06-14 2019-02-05 Microsoft Technolgy Licensing, LLC Suggesting a set of operations applicable to a selected range of data in a spreadsheet
CN103544250A (zh) * 2013-10-11 2014-01-29 华为技术有限公司 一种数据分析方法及装置
CN103699387A (zh) * 2013-12-27 2014-04-02 金蝶软件（中国）有限公司 表格处理方法和系统
CN104732418A (zh) * 2014-12-11 2015-06-24 科技先知有限公司 积分交易的系统及其方法
CN107257968A (zh) * 2015-02-27 2017-10-17 微软技术许可有限责任公司 发现电子表格中的独特公式集
CN109858000A (zh) * 2019-01-10 2019-06-07 广州视源电子科技股份有限公司 表格处理方法、装置、系统、存储介质及交互智能平板
CN110874644A (zh) * 2019-11-13 2020-03-10 第四范式（北京）技术有限公司 辅助用户探索数据集、数据表的方法及装置
CN110874644B (zh) * 2019-11-13 2025-09-12 第四范式（北京）技术有限公司 辅助用户探索数据集、数据表的方法及装置
CN119045690A (zh) * 2024-10-31 2024-11-29 一网互通(北京)科技有限公司 前端提示组件显示优化的实现方法及装置

Also Published As

Publication number Publication date
US20130145244A1 (en) 2013-06-06
JP2015507779A (ja) 2015-03-12
IN2014CN03963A (GUID-C5D7CC26-194C-43D0-91A1-9AE8C70A9BFF.html) 2015-09-04
EP2788852A4 (en) 2015-09-09
EP2788852A1 (en) 2014-10-15
RU2014122851A (ru) 2015-12-10
CA2857409A1 (en) 2013-06-13
BR112014013454A2 (pt) 2017-06-13
AU2012348174A1 (en) 2014-06-26
BR112014013454A8 (pt) 2017-12-12
KR20140105733A (ko) 2014-09-02
MX2014006732A (es) 2014-08-29
WO2013085727A1 (en) 2013-06-13

Similar Documents

Publication Publication Date Title
CN102982016A (zh) 用于电子表格应用程序的快速分析工具
US11703990B2 (en) Animated visual cues indicating the availability of associated content
US10896284B2 (en) Transforming data to create layouts
US10768772B2 (en) Context-aware recommendations of relevant presentation content displayed in mixed environments
US9183658B2 (en) Animation creation and management in presentation application programs
CN104520851A (zh) 基于电子表格应用中的数据点生成查询
CN106537371B (zh) 可视化建议
CN102982440A (zh) 聚集和呈现任务
CN102968312A (zh) 用于应用扩展程序的用户界面占位符
CN111868767B (zh) 基于用户洞察来驱动上下文感知的用户协作
CN104067215A (zh) 呈现数据驱动表单
US10433105B2 (en) Geographically-driven group communications
CN109074392A (zh) 知晓上下文的资源管理器
US20210158304A1 (en) Enhanced views and notifications of location and calendar information
CN110168588B (zh) 基于位置、使用模式以及内容来识别文档
CN103257997A (zh) 为视频及其他媒体内容启用复制和粘贴功能
US20160004712A1 (en) Query Suggestions
EP2592599B1 (en) Animation creation and management in presentation application programs
WO2018103039A1 (en) Machine learning in message distribution
HK1181164A (en) Quick analysis tool for spreadsheet application programs

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
REG Reference to a national code

Ref country code: HK

Ref legal event code: DE

Ref document number: 1181164

Country of ref document: HK

ASS Succession or assignment of patent right

Owner name: MICROSOFT TECHNOLOGY LICENSING LLC

Free format text: FORMER OWNER: MICROSOFT CORP.

Effective date: 20150728

C41 Transfer of patent application or patent right or utility model
TA01 Transfer of patent application right

Effective date of registration: 20150728

Address after: Washington State

Applicant after: Micro soft technique license Co., Ltd

Address before: Washington State

Applicant before: Microsoft Corp.

C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20130320

REG Reference to a national code

Ref country code: HK

Ref legal event code: WD

Ref document number: 1181164

Country of ref document: HK