Method and system for adjusting frozen region in spreadsheet

A spreadsheet and area technology, applied in electrical digital data processing, data processing input/output process, instruments, etc., can solve the problems of cumbersome operation and quick adjustment of unfavorable freezing areas, and achieve the effect of convenient operation and good user experience

Active Publication Date: 2015-11-04
ZHUHAI KINGSOFT OFFICE SOFTWARE +1
View PDF3 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, when the user needs to adjust the frozen area, he needs to cancel the existing frozen area first, and then perform the freezing operation again and select the area he wants to freeze to adjust the frozen area. The operation is cumbersome and is not conducive to the quick adjustment of the frozen area.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for adjusting frozen region in spreadsheet
  • Method and system for adjusting frozen region in spreadsheet
  • Method and system for adjusting frozen region in spreadsheet

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment approach

[0062] Method 1. S100 may include:

[0063] Obtain the position of the user's manipulation point;

[0064] determining the distance between the manipulation point and the freezing line of the current freezing area in the spreadsheet according to the position of the manipulation point;

[0065] When the distance is less than a preset distance threshold, switching the state of the freezing line whose distance from the control point is less than the preset distance threshold from a fixed state to a movable state;

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

Embodiments of the invention provide a method and a system for adjusting a frozen region in a spreadsheet. A dragging instruction of a user can be directly responded, a frost line is switched to a movable state, and then, the frost line is moved following the dragging instruction of the user, and a present frozen region is adjusted according to the frost line after movement. Therefore, a user does not need to perform a pane frosting operation after defrosting. The method and the system are more convenient in operation, rapid adjustment of the frozen region is realized, and usage feeling of a user is good.

Description

technical field [0001] The invention relates to the technical field of electronic forms, in particular to a method and system for adjusting frozen areas in electronic forms. Background technique [0002] With the development of science and technology, office software such as spreadsheets has become an indispensable and important software in people's work. [0003] Through the pane freezing function, users can freeze a certain area in the spreadsheet, so that they can still see the frozen area when switching the content of the table. To help users see frozen areas, spreadsheets use frozen lines to denote the boundaries of frozen areas. Users can conveniently freeze a certain row, column or area. [0004] However, when the user needs to adjust the frozen area, he needs to cancel the existing frozen area first, and then perform the freezing operation again and select the area he wants to freeze to adjust the frozen area. The operation is cumbersome and is not conducive to the...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F3/0484G06F3/0486
Inventor 王晖张伶俐曾思洁
Owner ZHUHAI KINGSOFT OFFICE SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap