JP2023513567A - テーブルの処理方法、装置、機器および記憶媒体 - Google Patents
テーブルの処理方法、装置、機器および記憶媒体 Download PDFInfo
- Publication number
- JP2023513567A JP2023513567A JP2022548604A JP2022548604A JP2023513567A JP 2023513567 A JP2023513567 A JP 2023513567A JP 2022548604 A JP2022548604 A JP 2022548604A JP 2022548604 A JP2022548604 A JP 2022548604A JP 2023513567 A JP2023513567 A JP 2023513567A
- Authority
- JP
- Japan
- Prior art keywords
- display area
- frozen
- region
- ratio
- area
- 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.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title abstract description 14
- 238000000034 method Methods 0.000 claims abstract description 37
- 230000009467 reduction Effects 0.000 claims abstract description 15
- 238000012545 processing Methods 0.000 claims description 23
- 238000004590 computer program Methods 0.000 claims description 12
- 238000007710 freezing Methods 0.000 claims description 9
- 230000008859 change Effects 0.000 claims description 6
- 238000005192 partition Methods 0.000 claims description 6
- 230000004044 response Effects 0.000 claims description 6
- 230000008569 process Effects 0.000 claims description 4
- 238000012544 monitoring process Methods 0.000 claims 1
- 230000006870 function Effects 0.000 description 10
- 238000010586 diagram Methods 0.000 description 9
- 230000008014 freezing Effects 0.000 description 7
- 230000003287 optical effect Effects 0.000 description 6
- 238000004891 communication Methods 0.000 description 3
- 238000007796 conventional method Methods 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/04845—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range for image manipulation, e.g. dragging, rotation, expansion or change of colour
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0485—Scrolling or panning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0485—Scrolling or panning
- G06F3/04855—Interaction with scrollbars
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- User Interface Of Digital Computer (AREA)
- Digital Computer Display Output (AREA)
- Document Processing Apparatus (AREA)
Abstract
Description
Claims (10)
- 凍結領域および非凍結領域を含むテーブル領域の表示エリアに対する前記凍結領域の表示エリアの割合を特定することと、
前記割合が割合閾値よりも大きい場合、前記テーブル領域の表示エリアに対する縮小後の前記凍結領域の表示エリアの割合が前記割合閾値と等しくなるように、前記凍結領域の表示エリアを縮小するとともに、前記非凍結領域の表示エリアを拡大することと、を含む、
テーブルの処理方法。 - 前記凍結領域の表示エリアを縮小するとともに、前記非凍結領域の表示エリアを拡大することは、
前記凍結領域の表示エリアと前記非凍結領域の表示エリアとの間の仕切線を、前記テーブル領域の表示エリアにおける前記割合に対応する位置である第1位置から前記割合閾値に対応する位置である第2位置に移動することと、
移動された前記仕切線に応じて、前記凍結領域の表示エリアおよび前記非凍結領域の表示エリアを調整することと、を含む、
請求項1に記載の方法。 - 前記凍結領域の表示エリアはスクロールバーを含み、
前記スクロールバーに対する移動操作をモニタし、前記移動操作に応じて、前記凍結領域の表示エリアに、前記凍結領域に含まれる内容を対応して表示させること、を更に含む、
請求項2に記載の方法。 - 入力された凍結解除命令を取得することと、
前記凍結解除命令に応じて、前記凍結領域の凍結を解除することと、を更に含む、
請求項1~3のいずれか一項に記載の方法。 - 目標テーブルを閉じる命令がモニタされた場合、凍結解除後の前記凍結領域を再び凍結すること、を更に含む、
請求項4に記載の方法。 - 前記割合が割合閾値以下である場合、前記凍結領域の表示エリアおよび前記非凍結領域の表示エリアのサイズは変化しない、
請求項1~3のいずれか一項に記載の方法。 - テーブル領域の表示エリアに対する凍結領域の表示エリアの割合を特定することは、
前記凍結領域の表示エリアに含まれるライン数および前記テーブル領域の表示エリアに含まれるライン数に応じて、前記テーブル領域の表示エリアに対する前記凍結領域の表示エリアの割合を特定し、前記ライン数が行数または列数であること、を含む、
請求項1~3のいずれか一項に記載の方法。 - 凍結領域および非凍結領域を含むテーブル領域の表示エリアに対する前記凍結領域の表示エリアの割合を特定するように構成されている特定モジュールと、
前記割合が割合閾値よりも大きい場合、前記テーブル領域の表示エリアに対する縮小後の前記凍結領域の表示エリアの割合が前記割合閾値と等しくなるように、前記凍結領域の表示エリアを縮小するとともに、前記非凍結領域の表示エリアを拡大するように構成されている第1処理モジュールと、を備える、
テーブルの処理装置。 - メモリと、プロセッサとを備え、
前記メモリには、前記プロセッサに実行されると、請求項1~7のいずれか一項に記載の方法におけるステップを実現するコンピュータプログラムが記憶されている、
電子機器。 - プロセッサに実行されると、請求項1~7のいずれか一項に記載の方法を実現するコンピュータプログラムが記憶されている、
コンピュータ可読記憶媒体。
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010086796.2 | 2020-02-11 | ||
CN202010086796.2A CN111309798B (zh) | 2020-02-11 | 2020-02-11 | 表格的处理方法、装置、设备和存储介质 |
PCT/CN2021/075906 WO2021160077A1 (zh) | 2020-02-11 | 2021-02-08 | 表格的处理方法、装置、设备和存储介质 |
Publications (2)
Publication Number | Publication Date |
---|---|
JP2023513567A true JP2023513567A (ja) | 2023-03-31 |
JP7477623B2 JP7477623B2 (ja) | 2024-05-01 |
Family
ID=71150953
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
JP2022548604A Active JP7477623B2 (ja) | 2020-02-11 | 2021-02-08 | テーブルの処理方法、装置、機器および記憶媒体 |
Country Status (5)
Country | Link |
---|---|
US (1) | US20220284181A1 (ja) |
EP (1) | EP4105790A4 (ja) |
JP (1) | JP7477623B2 (ja) |
CN (1) | CN111309798B (ja) |
WO (1) | WO2021160077A1 (ja) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111309798B (zh) * | 2020-02-11 | 2023-05-12 | 北京字节跳动网络技术有限公司 | 表格的处理方法、装置、设备和存储介质 |
CN113625917A (zh) * | 2021-07-29 | 2021-11-09 | 北京达佳互联信息技术有限公司 | 数据展示方法、装置、电子设备、存储介质及产品 |
Family Cites Families (18)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6549878B1 (en) * | 1998-12-31 | 2003-04-15 | Microsoft Corporation | System and method for editing a spreadsheet via an improved editing and cell selection model |
US6988241B1 (en) * | 2000-10-16 | 2006-01-17 | International Business Machines Corporation | Client side, web-based spreadsheet |
WO2004109557A1 (en) * | 2003-06-03 | 2004-12-16 | Forbes Holten Norris, Iii | Flexible, dynamic menu-based web-page architecture |
US20050154974A1 (en) * | 2004-01-14 | 2005-07-14 | International Business Machines Corporation | Method, apparatus and program storage device for inline controlling of row and column sets in tabular displays |
US7930323B2 (en) * | 2004-12-30 | 2011-04-19 | Sap Ag | Method for reallocating table formats in real-time |
CN100424700C (zh) * | 2006-03-06 | 2008-10-08 | 阿里巴巴集团控股有限公司 | 在网页中实现表格局部滚动显示的方法及系统 |
US7779346B2 (en) | 2006-10-03 | 2010-08-17 | Research In Motion Limited | System and method for freezing columns and rows in a UI table |
US20090083614A1 (en) * | 2007-09-26 | 2009-03-26 | Xerox Corporation | System and method for optimizing information display in spreadsheets and tables |
US8312367B2 (en) | 2009-10-30 | 2012-11-13 | Synopsys, Inc. | Technique for dynamically sizing columns in a table |
US9195780B2 (en) * | 2011-09-30 | 2015-11-24 | Oracle International Corporation | Computer user interface including a data grid with a persistent display portion |
US20130111391A1 (en) * | 2011-11-01 | 2013-05-02 | Microsoft Corporation | Adjusting content to avoid occlusion by a virtual input panel |
US9760271B2 (en) * | 2014-07-28 | 2017-09-12 | International Business Machines Corporation | Client-side dynamic control of visualization of frozen region in a data table |
CN105677624B (zh) * | 2014-11-20 | 2018-10-16 | 珠海金山办公软件有限公司 | 一种电子表格冻结区域调整方法及装置 |
US9933931B2 (en) * | 2015-06-23 | 2018-04-03 | Microsoft Technology Licensing Llc | Freeze pane with snap scrolling |
JP6716873B2 (ja) * | 2015-08-10 | 2020-07-01 | 富士通株式会社 | データ処理方法、データ処理プログラムおよび情報処理装置 |
CN107544952B (zh) * | 2017-08-28 | 2022-01-07 | 金蝶软件(中国)有限公司 | 报表生成方法、装置、存储介质和计算机设备 |
CN110968987B (zh) * | 2018-09-30 | 2022-05-20 | 腾讯科技(深圳)有限公司 | 表格显示方法和装置、存储介质及电子装置 |
CN111309798B (zh) * | 2020-02-11 | 2023-05-12 | 北京字节跳动网络技术有限公司 | 表格的处理方法、装置、设备和存储介质 |
-
2020
- 2020-02-11 CN CN202010086796.2A patent/CN111309798B/zh active Active
-
2021
- 2021-02-08 WO PCT/CN2021/075906 patent/WO2021160077A1/zh unknown
- 2021-02-08 EP EP21754497.2A patent/EP4105790A4/en active Pending
- 2021-02-08 JP JP2022548604A patent/JP7477623B2/ja active Active
-
2022
- 2022-05-27 US US17/826,486 patent/US20220284181A1/en active Pending
Also Published As
Publication number | Publication date |
---|---|
EP4105790A1 (en) | 2022-12-21 |
CN111309798B (zh) | 2023-05-12 |
CN111309798A (zh) | 2020-06-19 |
WO2021160077A1 (zh) | 2021-08-19 |
JP7477623B2 (ja) | 2024-05-01 |
EP4105790A4 (en) | 2023-06-28 |
US20220284181A1 (en) | 2022-09-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11178448B2 (en) | Method, apparatus for processing video, electronic device and computer-readable storage medium | |
CN110046021B (zh) | 一种页面显示方法、装置、系统、设备和存储介质 | |
CN111399956B (zh) | 应用于显示设备的内容展示方法、装置和电子设备 | |
US20220308741A1 (en) | Method and apparatus for displaying video, electronic device and medium | |
CN109976620B (zh) | 列表项展现属性信息的确定方法、装置、设备及存储介质 | |
CN111291244B (zh) | 房源信息展示方法、装置、终端及存储介质 | |
WO2021135626A1 (zh) | 菜单项选择方法、装置、可读介质及电子设备 | |
US20230015800A1 (en) | A method, apparatus, medium and electronic device for configuring a gift list in a live broadcast room | |
US20220284181A1 (en) | Table processing method and apparatus, device and storage medium | |
US11863835B2 (en) | Interaction method and apparatus, and electronic device | |
US11849211B2 (en) | Video processing method, terminal device and storage medium | |
CN114491349B (zh) | 页面显示方法、装置、电子设备、存储介质和程序产品 | |
US20230421857A1 (en) | Video-based information displaying method and apparatus, device and medium | |
WO2023125164A1 (zh) | 页面显示方法、装置、电子设备和存储介质 | |
CN110795196A (zh) | 窗口显示方法、装置、终端及存储介质 | |
CN111240793B (zh) | cell预渲染的方法、装置、电子设备以及计算机可读介质 | |
US11783865B2 (en) | Method and apparatus for displaying video playback page, and electronic device and medium | |
CN111258736A (zh) | 信息处理方法、装置和电子设备 | |
CN113535105B (zh) | 媒体文件处理方法、装置、设备、可读存储介质及产品 | |
US20240126422A1 (en) | Progress adjustment method and apparatus, electronic device and storage medium | |
CN110611847A (zh) | 视频预览的方法、装置、存储介质及电子设备 | |
US20240094883A1 (en) | Message selection method, apparatus and device | |
CN110134905B (zh) | 一种页面更新显示方法、装置、设备及存储介质 | |
US20230421623A1 (en) | Presentation method and apparatus, and electronic device | |
CN110069186B (zh) | 显示应用的操作界面的方法和设备 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
A621 | Written request for application examination |
Free format text: JAPANESE INTERMEDIATE CODE: A621 Effective date: 20220810 |
|
A977 | Report on retrieval |
Free format text: JAPANESE INTERMEDIATE CODE: A971007 Effective date: 20230928 |
|
A131 | Notification of reasons for refusal |
Free format text: JAPANESE INTERMEDIATE CODE: A131 Effective date: 20231003 |
|
A521 | Request for written amendment filed |
Free format text: JAPANESE INTERMEDIATE CODE: A523 Effective date: 20231227 |
|
TRDD | Decision of grant or rejection written | ||
A01 | Written decision to grant a patent or to grant a registration (utility model) |
Free format text: JAPANESE INTERMEDIATE CODE: A01 Effective date: 20240326 |
|
A61 | First payment of annual fees (during grant procedure) |
Free format text: JAPANESE INTERMEDIATE CODE: A61 Effective date: 20240418 |
|
R150 | Certificate of patent or registration of utility model |
Ref document number: 7477623 Country of ref document: JP Free format text: JAPANESE INTERMEDIATE CODE: R150 |