CN112905090A - Spreadsheet processing method, device, terminal and storage medium - Google Patents
Spreadsheet processing method, device, terminal and storage medium Download PDFInfo
- Publication number
- CN112905090A CN112905090A CN202110171996.2A CN202110171996A CN112905090A CN 112905090 A CN112905090 A CN 112905090A CN 202110171996 A CN202110171996 A CN 202110171996A CN 112905090 A CN112905090 A CN 112905090A
- Authority
- CN
- China
- Prior art keywords
- data
- cell
- verification
- check
- options
- 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
Links
Images
Classifications
-
- 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/04842—Selection of displayed objects or displayed text elements
-
- 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/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Human Computer Interaction (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The disclosure provides a spreadsheet processing method, device, terminal and storage medium. In some embodiments, the present disclosure provides a method of processing a spreadsheet, comprising: responding to first operations of at least two data options in a data option interface of the first cell, and determining corresponding at least two first data; the data option interface displays data options, and the data options correspond to data; at least two first data are displayed in the first cell. The method disclosed by the invention can display at least two first data in the first cell instead of connecting the at least two first data into a character string for displaying, and each first data is independent, so that the data coupling is released, and the independent processing of each first data can be realized.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a method and an apparatus for processing an electronic form, a terminal, and a storage medium.
Background
The spreadsheet may be an online spreadsheet or a local spreadsheet, and the cells in the spreadsheet may be entered with values that meet the rules by selecting options from a drop-down list.
Disclosure of Invention
In order to solve the existing problems, the present disclosure provides a method, an apparatus, a terminal, and a storage medium for processing a spreadsheet.
The present disclosure adopts the following technical solutions.
In some embodiments, the present disclosure provides a method of processing a spreadsheet, comprising:
responding to first operations of at least two data options in a data option interface of the first cell, and determining corresponding at least two first data; the data option interface displays data options, and the data options correspond to data;
at least two first data are displayed in the first cell.
In some embodiments, the present disclosure provides an apparatus for processing a spreadsheet, comprising:
the determining unit is used for responding to first operation of at least two data options in the data option interface of the first cell and determining at least two corresponding first data; the data option interface displays data options, and the data options correspond to data;
and the display unit is used for displaying at least two first data in the first cell.
In some embodiments, the present disclosure provides a terminal comprising: at least one memory and at least one processor;
the memory is used for storing program codes, and the processor is used for calling the program codes stored in the memory to execute the method.
In some embodiments, the present disclosure provides a storage medium for storing program code for performing the above-described method.
In some embodiments of the present disclosure, instead of displaying at least two first data in a string in a connected manner in the first cell, the first data are independent from each other, and the data are decoupled, so that the first data can be processed separately.
Drawings
The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and elements are not necessarily drawn to scale.
Fig. 1 is a flowchart of a form processing method according to an embodiment of the present disclosure.
Fig. 2a to 2c are schematic diagrams of a table in the process of executing a table processing method according to an embodiment of the disclosure.
Fig. 3 is a block diagram of a form processing apparatus according to an embodiment of the present disclosure.
Fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it is to be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein, but rather are provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.
It should be understood that various steps recited in method embodiments of the present disclosure may be performed in parallel and/or in parallel. Moreover, method embodiments may include additional steps and/or omit performing the illustrated steps. The scope of the present disclosure is not limited in this respect.
The term "include" and variations thereof as used herein are open-ended, i.e., "including but not limited to". The term "based on" is "based, at least in part, on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". Relevant definitions for other terms will be given in the following description.
It should be noted that the terms "first", "second", and the like in the present disclosure are only used for distinguishing different devices, modules or units, and are not used for limiting the order or interdependence relationship of the functions performed by the devices, modules or units.
It is noted that references to "a" or "an" in this disclosure are intended to be illustrative rather than limiting, and that those skilled in the art will recognize that reference to "one or more" unless the context clearly dictates otherwise.
The names of messages or information exchanged between devices in the embodiments of the present disclosure are for illustrative purposes only, and are not intended to limit the scope of the messages or information.
The embodiments of the present application will be described in detail below with reference to the accompanying drawings.
In the related art, in a spreadsheet, such as an Excel form, a drop-down list may be set, options may be set in the drop-down list, and a user may input a selected option in a cell of the spreadsheet by clicking the option, and in the related art, a numerical value in a cell of the spreadsheet is identified by a variable, so that only one value can be input in one cell, and assuming that the user inputs "2, 5, 6", it seems that 3 values are input, and actually a character string is input, and a single value is still input, not a plurality of numerical values, a direct proof is that when a digit is displayed after setting the numerical format of the cell to a decimal point, the value in the cell is still "2, 5, 6", and does not become "2.0, 5.0, 6.0".
The embodiment of the present disclosure provides a method for processing an electronic form, as shown in fig. 1, including:
as shown in fig. 1, fig. 1 is a flowchart of a processing method of a spreadsheet according to an embodiment of the present disclosure, including the following steps.
S11: in response to a first operation on at least two data options in a data option interface of a first cell, corresponding at least two first data are determined.
In some embodiments, the first cell is any table in an electronic table, the data option interface is an interface for selecting data, and may be, for example, a pull-down interface, a data option is displayed in the data option interface, the data option corresponds to data, and the first data is data corresponding to the data option on which the first operation is performed. In some embodiments, the first operation may be an operation of selecting two data at a time, or may be an operation including selecting data twice in sequence.
At least two first data are displayed in the first cell S12.
In some embodiments, two first data are displayed in the first cell, and multiple values, rather than single values, are displayed in the first cell, and a variable may be set for each first data for identification. In the related art, the numerical value input in the cell is a single value, which will be described below by way of example.
As shown in fig. 2a to 2C, fig. 2a is an electronic form in some embodiments, wherein a data option is set in the extra long column, a drop-down list of the extra long column is called by clicking a triangle symbol in the extra long column in the row of "zhang san", and as shown in fig. 2b, the drop-down list has a plurality of data options, including "C + + programming", "JAVA programming", and "PHP programming", and the first operation may be, for example, a selection operation, and assuming that a user selects the options corresponding to "C + + programming" and "JAVA programming", two first data are displayed in the extra long column in the row of "zhang san" as shown in fig. 2C, and are respectively "C + + programming" and "JAVA" programming, that is, a plurality of data are displayed in one cell, instead of connecting "C + + programming" and "JAVA programming" into one character string for display.
In some embodiments of the present disclosure, instead of connecting at least two first data into one string for display, the first data are independent from each other, and the data coupling is removed, in the related art, two data cannot be input into one cell, and the data in one cell is merged into one string, so that the two data are actually one data, which causes strong coupling, and when the cell is processed, only the data merged into one string can be processed.
In some embodiments of the present disclosure, further comprising: and responding to a second operation on at least one second cell in the spreadsheet, and performing data verification on second data in the second cell according to the data verification rule.
In some embodiments, the second cell is any cell in the spreadsheet, the second data in the second cell may be data input by the user, but not data selected from the data option interface, at this time, the second data in the second cell may not comply with the data verification rule, the second cell may be the same cell as the first cell or may be different cells, the second operation may be, for example, a data verification operation, the data verification rule may be preset, for example, only the contents in several predetermined options are allowed to be input in the cell, for example, assuming that the second cell is a place cell, three data options are preset, and the corresponding data are "beijing", "shanghai" and "shenzhen", and the user inputs the second data in the second cell, the data verification is performed on the second data input by the user, and determining whether the input second data is one or more of 'Beijing', 'Shanghai' and 'Shenzhen', if so, determining that the second data is a valid value, otherwise, determining that the second data is an invalid value, and setting a data verification rule to determine whether the data input by the user is valid under the condition that the user manually inputs the data, so as to avoid the exception caused by the invalid value input when the data is processed.
In some embodiments of the present disclosure, the second cell has at least two second data, and the data check is performed on the at least two second data in the second cell respectively. In some embodiments of the disclosure, at least two second data are stored in the second cell, and at this time, it is respectively determined whether each second data meets the data verification rule, in the related art, the data stored in one cell of the spreadsheet is one data, and data verification can be only performed on the data in the cell as a whole, for example, assuming that the second cell is a place cell, three data options are preset, the corresponding data are respectively "beijing", "shanghai", and "shenzhen", only the data corresponding to the above options are allowed to be input, the user inputs "beijing" and "tianjin" in the second cell, it is determined that "beijing" meets the data verification rule during data verification, and "tianjin" does not meet the data verification rule, in the related art, if the user data "beijing, tianjin" in one cell, the cell combines the characters into a character string, the whole character string of Beijing and Tianjin is verified during data verification, and the verification result is that the data in the character string does not accord with the data verification rule. Some embodiments of the present disclosure may perform data verification on each second data in the second cell, respectively, because each data in the cell is decoupled, thereby determining whether each second data conforms to the data verification rule.
In some embodiments of the present disclosure, performing a data check on the second data in the second cell includes: determining whether the check result cache of the second cell is empty; if not, obtaining a check result from a check result cache; and if the data is empty, verifying the second data according to a data verification formula, and updating the verification result into a verification result cache.
In some embodiments, each cell of the online table may be provided with a corresponding check result cache, the check result cache is empty when data check is performed for the first time, and the check result cache is not empty when data check is performed for the next time, so that the last check result can be directly obtained from the check result cache, and therefore, one cell does not need to be repeatedly checked, the calculation amount is reduced, and the response speed is improved.
In some embodiments of the present disclosure, before determining whether the second data has the corresponding check result cached, the method further includes: and determining whether the data check rule corresponding to the second cell has a corresponding data check formula. If the corresponding data check formula exists, determining whether the second data has a corresponding check result cache; and if the corresponding data verification formula does not exist, generating a data verification formula according to the data verification rule, performing data verification on the second data according to the generated data verification formula, and updating the data verification result to the verification result cache of the second cell.
In some embodiments, a data check formula is used for data check of second data to be checked during data check, so that it is required to determine whether a data check formula exists first, and if not, the data check formula needs to be generated first. And then, performing data verification on the second data to be verified by using a data verification formula, and caching the data verification result into a verification result cache.
In some embodiments of the present disclosure, further comprising: and in response to the modification operation on the value and/or format of the data in the third cell, emptying the check result cache corresponding to the third cell.
In some embodiments, the third cell may be any cell, and may be the same as the first cell or the second cell, and after at least one of the data value or the data format in the third cell is modified, the data in the third cell may no longer conform to the data verification rule, and at this time, if the verification result is still obtained from the verification result cache, the data may be inaccurate, so that the verification result cache of the third cell is cleared, and when the data is verified for the third cell, the data needs to be newly verified, instead of obtaining the verification result from the verification result cache, so as to ensure the correctness of the verification result.
In some embodiments of the present disclosure, further comprising: and emptying the verification result cache of the cell using the data verification rule in response to the modification operation of the data verification rule. In some embodiments, after the data check rule is changed, for the cell using the data check rule, the check result in the check result cache may no longer be correct, and therefore, for the cell using the data check rule, the check result cache needs to be cleared, so that the check result is recalculated and obtained when the data check is performed.
In some embodiments of the present disclosure, a target variable serving as a check object is provided in the data check formula, where the target variable is a return value of a target method, and the target method is used to obtain a cell currently subjected to data check.
In some embodiments, the mount cell is a cell currently performing data verification, and the reference area is a cell referred in the data verification formula. When data verification is performed, different cells may use the same data verification formula, and different cells in the spreadsheet in the related art have different mount cells and reference areas when the data verification formula is used, for example: the cell 1 refers to itself when using the data check formula, and the cell 2 refers to itself when using the data check formula; therefore, each cell needs to be compiled and used with the data check formula, which causes the data check formula to be repeatedly compiled and occupies a large amount of memory. In some embodiments of the present disclosure, a target variable ref is used as a substitute in a data check formula, the data check formula checks the target variable, the target variable is equal to a return value of a target method getref (), the target method getref () is used to obtain a cell currently performing data check, i.e. a mounted cell, therefore, when compiling the formula, the data check formula only processes the target variable ref without specific data, and does not refer to a specific cell, but when using the formula, dynamically replaces the mounted cell and the reference region according to the cell currently performing data check, so that no matter how many cells refer to the same data check formula, the data check formula only needs to be compiled once, and the occupation of a memory is greatly reduced by a dynamic replacement method, and the amount of compilation processing.
In some embodiments of the present disclosure, further comprising; and clearing the data with the data format in the fourth cell as the non-preset format in response to the first operation on the data option in the data option interface of the fourth cell. In some embodiments, a data format of data that can be stored in a cell is preset, and after a user selects data through a data option interface, data in a non-preset format in the cell is removed, for example, a pull-down list is provided in the data option interface, the non-preset format includes a picture format, and after one or more options are selected through the pull-down list, the picture in the cell is removed.
In some embodiments of the present disclosure, further comprising: and responding to a third operation in the fifth cell, and respectively setting a data format for at least two third data in the fifth cell, wherein the fifth cell has at least two third data. In the related art, only one data can be stored in one cell, and a plurality of data input in one cell can be merged into one in time, so that the plurality of data in one cell cannot be processed in a separate format, but in some embodiments of the present disclosure, a fifth cell may be any cell in a spreadsheet, and since at least two third data are stored in the fifth cell, a data format may be set for the third data, for example, "0.3, 0.5" is input in one cell, and in the related art, if the cell is set as a percentage, the data in the cell is considered as one data and cannot be converted into a percentage, whereas in some embodiments of the present disclosure, two data are stored, and therefore, the data can be converted into "30%, 50%".
In some embodiments of the present disclosure, further comprising: splitting fourth data in the sixth cell into at least two fifth data in response to a fourth operation on the sixth cell; and setting the data options of the data option interface of the fourth cell according to the at least two fifth data.
In some embodiments, the sixth cell is any cell in the spreadsheet, the sixth cell originally stores one data, that is, the fourth data is split into at least two fifth data through a fourth operation, and the fifth data in the cell is data corresponding to the data option which is the data option interface. For example, a character string "beijing, shanghai" is stored in one cell, and is split into "beijing" and "shanghai" by executing a fourth operation, and data options corresponding to "beijing" and "shanghai" are added to the drop-down list of the cell respectively. In some embodiments of the present disclosure, a single data is split into multiple data, and data options are automatically adjusted, so that data in a cell is guaranteed to meet data validation rules while splitting.
In some embodiments of the present disclosure, splitting the fourth data in the sixth cell into at least two fifth data includes: recognizing a preset identifier in the fourth data; and cutting the fourth data according to the preset identification. In some embodiments, the preset identifier may be, for example, a comma or a semicolon, and the position of the preset identifier serves as a splitting site, so as to split the fourth data.
In some embodiments of the present disclosure, before splitting the fourth data in the fourth cell into at least two fifth data, further comprising: determining whether the fourth data is data of a preset type; if the fourth data is data of a preset type, splitting the fourth data; and if the fourth data is not the data of the preset type, not splitting the fourth data. In some embodiments, the preset type may be a character string, for example, and in some embodiments, data of a partial type may not be split, for example, data in a picture format, so that the preset type needs to be set.
In some embodiments of the present disclosure, further comprising: in response to a fifth operation on the seventh cell, merging at least two sixth data in the seventh cell into seventh data; wherein, the seventh data is single-value data; and setting the data options of the data option interface of the seventh cell according to at least seventh data. In some embodiments, the seventh cell may be any cell in a spreadsheet, the seventh cell has at least two sixth data therein, the seventh cell is merged into one seventh data, and data options are set so as to ensure that the merged seventh data conforms to the data validation rule, and in some embodiments, the single value data refers to a single data, such as a single character string, which is distinguished from a plurality of data, but the single value data may not limit the length and composition of the data, and may be, for example, a character string consisting of one or more of letters, numbers and symbols. According to the method in the embodiment of the disclosure, the data options can be automatically generated according to the data in the cells, manual operation of a user is not needed, and the use experience of the user is improved.
In some embodiments of the present disclosure, the preset identifier is not allowed to exist in the data corresponding to the data option of the data option interface of any cell. In some embodiments, a user may perform merging processing and splitting processing on multiple data in a cell after merging processing, if a preset identifier exists in data of a data option in the cell and the user selects data with the preset identifier, the data merged and split in the cell is inconsistent with the multiple data before merging, so that the merging and splitting are irreversible, and therefore, the preset identifier is not allowed to exist in data corresponding to the data option in the data option interface of any cell, so as to ensure the reversibility of the merging and splitting processes of the data.
In some embodiments of the present disclosure, a cell in a spreadsheet has a first attribute for identifying whether a plurality of data can be stored within the cell. In some embodiments, one data may be stored in a cell, or a plurality of data may be stored, and the number of data that can be stored is limited by adjusting the first data. If the first attribute identification can store a plurality of data, the user can store one or at least two data therein, and if the first attribute identification can store one data, two or more data cannot be stored.
In some embodiments of the present disclosure, further comprising: and in response to the fact that the first attribute of the eighth cell is changed from the storage of a plurality of data to the storage of single data, acquiring first data selected according to a preset sequence in the eighth cell as data in the eighth cell. In some embodiments, the eighth cell is any cell in the spreadsheet, in the case that multiple data can be originally stored in the eighth cell, if one data is limited to be stored in the eighth cell, one data is selected from the data originally stored in the eighth cell as the data of the eighth cell, in some embodiments, the preset sequence may be from left to right, which is in accordance with the common usage habit, in other embodiments, if multiple data are originally stored in the eighth cell before the first attribute is modified, after the first data is modified, the unselected data is not abandoned, but is still stored in the eighth cell, but is not displayed, any reference referencing the eighth cell only returns the first data selected according to the preset sequence displayed in the eighth cell, so that, when the first data of the eighth cell is modified, the multiple data can be stored, all the data originally in the eighth cell may be automatically displayed.
In some embodiments of the present disclosure, a processing apparatus of a spreadsheet is also provided, as shown in fig. 3, including:
the determining unit 10 is configured to determine, in response to a first operation on at least two data options in the data option interface of the first cell, corresponding at least two pieces of first data; the data option interface displays data options, and the data options correspond to data;
a display unit 20 for displaying at least two first data in the first cell.
For the embodiments of the apparatus, since they correspond substantially to the method embodiments, reference may be made to the partial description of the method embodiments for relevant points. The above-described apparatus embodiments are merely illustrative, wherein the modules described as separate modules may or may not be separate. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
The method and apparatus of the present disclosure have been described above based on the embodiments and application examples. In addition, the present disclosure also provides a terminal and a storage medium, which are described below.
Referring now to fig. 4, a schematic diagram of an electronic device (e.g., a terminal device or server) 800 suitable for use in implementing embodiments of the present disclosure is shown. The terminal device in the embodiments of the present disclosure may include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (personal digital assistant), a PAD (tablet computer), a PMP (portable multimedia player), a vehicle terminal (e.g., a car navigation terminal), and the like, and a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device shown in the drawings is only an example and should not bring any limitation to the functions and use range of the embodiments of the present disclosure.
The electronic device 800 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 801 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)802 or a program loaded from a storage means 808 into a Random Access Memory (RAM) 803. In the RAM803, various programs and data necessary for the operation of the electronic apparatus 800 are also stored. The processing apparatus 801, the ROM 802, and the RAM803 are connected to each other by a bus 804. An input/output (I/O) interface 805 is also connected to bus 804.
Generally, the following devices may be connected to the I/O interface 805: input devices 806 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 807 including, for example, a Liquid Crystal Display (LCD), speakers, vibrators, and the like; storage 808 including, for example, magnetic tape, hard disk, etc.; and a communication device 809. The communication means 809 may allow the electronic device 800 to communicate wirelessly or by wire with other devices to exchange data. While the figure illustrates an electronic device 800 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided.
In particular, according to an embodiment of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication means 809, or installed from the storage means 808, or installed from the ROM 802. The computer program, when executed by the processing apparatus 801, performs the above-described functions defined in the methods of the embodiments of the present disclosure.
It should be noted that the computer readable medium in the present disclosure can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In contrast, in the present disclosure, a computer readable signal medium may comprise a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network Protocol, such as HTTP (HyperText Transfer Protocol), and may interconnect with any form or medium of digital data communication (e.g., a communications network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed network.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device.
The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to perform the methods of the present disclosure as described above.
Computer program code for carrying out operations for aspects of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of an element does not in some cases constitute a limitation on the element itself.
The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), systems on a chip (SOCs), Complex Programmable Logic Devices (CPLDs), and the like.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
According to one or more embodiments of the present disclosure, there is provided a spreadsheet processing method including: responding to first operations of at least two data options in a data option interface of the first cell, and determining corresponding at least two first data; the data option interface displays data options, and the data options correspond to data;
at least two first data are displayed in the first cell.
According to one or more embodiments of the present disclosure, there is provided a method of processing a spreadsheet, further comprising: and responding to a second operation on at least one second cell in the spreadsheet, and performing data verification on second data in the second cell according to the data verification rule.
According to one or more embodiments of the present disclosure, a method for processing a spreadsheet is provided, where the second cell has at least two second data, and the at least two second data in the second cell are respectively subjected to data verification.
According to one or more embodiments of the present disclosure, there is provided a method for processing a spreadsheet, for performing data check on second data in a second cell, including:
determining whether the check result cache of the second cell is empty;
if not, obtaining a check result from a check result cache;
and if the data is empty, verifying the second data according to a data verification formula, and updating the verification result into a verification result cache.
According to one or more embodiments of the present disclosure, before determining whether the second data has a corresponding check result cached, a method for processing a spreadsheet further includes: determining whether the data check rule corresponding to the second cell has a corresponding data check formula;
if the corresponding data check formula exists, determining whether the second data has a corresponding check result cache;
and if the corresponding data verification formula does not exist, generating a data verification formula according to the data verification rule, performing data verification on the second data according to the generated data verification formula, and updating the data verification result to the verification result cache of the second cell.
According to one or more embodiments of the present disclosure, there is provided a method of processing a spreadsheet, further comprising: responding to modification operation on the value and/or format of the data in the third cell, and emptying the check result cache corresponding to the third cell; and/or the presence of a gas in the gas,
and emptying the verification result cache of the cell using the data verification rule in response to the modification operation of the data verification rule.
According to one or more embodiments of the present disclosure, a method for processing a spreadsheet is provided, where a target variable serving as a check object is provided in a data check formula, the target variable is a return value of a target method, and the target method is used to obtain a cell currently subjected to data check.
According to one or more embodiments of the present disclosure, there is provided a method of processing a spreadsheet, further comprising; and clearing the data with the data format in the fourth cell as the non-preset format in response to the first operation on the data option in the data option interface of the fourth cell.
According to one or more embodiments of the present disclosure, there is provided a method of processing a spreadsheet, further comprising: and responding to a third operation in the fifth cell, and respectively setting a data format for at least two third data in the fifth cell, wherein the fifth cell has at least two third data.
According to one or more embodiments of the present disclosure, there is provided a method of processing a spreadsheet, further comprising: splitting fourth data in the sixth cell into at least two fifth data in response to a fourth operation on the sixth cell;
and setting the data options of the data option interface of the fourth cell according to the at least two fifth data.
According to one or more embodiments of the present disclosure, there is provided a spreadsheet processing method, splitting fourth data in a sixth cell into at least two fifth data, including:
recognizing a preset identifier in the fourth data;
and cutting the fourth data according to the preset identification.
According to one or more embodiments of the present disclosure, before splitting the fourth data in the fourth cell into at least two fifth data, a method for processing a spreadsheet further includes:
determining whether the fourth data is data of a preset type;
if the fourth data is data of a preset type, splitting the fourth data;
and if the fourth data is not the data of the preset type, not splitting the fourth data.
According to one or more embodiments of the present disclosure, there is provided a method of processing a spreadsheet, further comprising:
in response to a fifth operation on the seventh cell, merging at least two sixth data in the seventh cell into seventh data; wherein, the seventh data is single-value data;
and setting the data options of the data option interface of the seventh cell according to at least seventh data.
According to one or more embodiments of the present disclosure, a method for processing a spreadsheet is provided, in which a preset identifier is not allowed to exist in data corresponding to a data option of a data option interface of any cell.
According to one or more embodiments of the present disclosure, a method for processing a spreadsheet is provided, a cell in the spreadsheet has a first attribute, and the first attribute is used for identifying whether a plurality of data can be stored in the cell.
According to one or more embodiments of the present disclosure, there is provided a method of processing a spreadsheet, further comprising: and in response to the fact that the first attribute of the eighth cell is changed from the storage of a plurality of data to the storage of single data, acquiring first data selected according to a preset sequence in the eighth cell as data in the eighth cell.
According to one or more embodiments of the present disclosure, there is provided a processing apparatus of a spreadsheet, including:
the determining unit is used for responding to first operation of at least two data options in the data option interface of the first cell and determining at least two corresponding first data; the data option interface displays data options, and the data options correspond to data;
and the display unit is used for displaying at least two first data in the first cell.
According to one or more embodiments of the present disclosure, there is provided a terminal including: at least one memory and at least one processor;
wherein the at least one memory is configured to store program code, and the at least one processor is configured to call the program code stored in the at least one memory to perform the method of any one of the above.
According to one or more embodiments of the present disclosure, there is provided a storage medium for storing program code for performing the above-described method.
The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the disclosure herein is not limited to the particular combination of features described above, but also encompasses other embodiments in which any combination of the features described above or their equivalents does not depart from the spirit of the disclosure. For example, the above features and (but not limited to) the features disclosed in this disclosure having similar functions are replaced with each other to form the technical solution.
Further, while operations are depicted in a particular order, this should not be understood as requiring that such operations be performed in the particular order shown or in sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Likewise, while several specific implementation details are included in the above discussion, these should not be construed as limitations on the scope of the disclosure. Certain features that are described in the context of separate embodiments can also be implemented in combination in a single embodiment. Conversely, various features that are described in the context of a single embodiment can also be implemented in multiple embodiments separately or in any suitable subcombination.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims.
Claims (19)
1. A method of spreadsheet processing, comprising:
responding to first operations of at least two data options in a data option interface of the first cell, and determining corresponding at least two first data; the data options are displayed in the data option interface, and the data options correspond to data;
displaying the at least two first data in the first cell.
2. The method of claim 1, further comprising:
and responding to a second operation on at least one second cell in the spreadsheet, and performing data verification on second data in the second cell according to the data verification rule.
3. The method of claim 2,
the second cell has at least two second data, and the data verification is performed on the at least two second data in the second cell respectively.
4. The method of claim 2, wherein performing a data check on the second data in the second cell comprises:
determining whether the check result cache of the second cell is empty;
if not, obtaining a check result from the check result cache;
and if the second data is empty, verifying the second data according to a data verification formula, and updating the verification result into a verification result cache.
5. The method of claim 4,
before determining whether the second data has the corresponding check result cached, the method further includes: determining whether the data check rule corresponding to the second cell has a corresponding data check formula;
if the corresponding data check formula exists, determining whether the second data has a corresponding check result cache;
and if the corresponding data verification formula does not exist, generating a data verification formula according to the data verification rule, performing data verification on the second data according to the generated data verification formula, and updating the data verification result to the verification result cache of the second cell.
6. The method of claim 4, further comprising:
responding to modification operation on the value and/or format of data in a third cell, and emptying a check result cache corresponding to the third cell; and/or the presence of a gas in the gas,
and emptying the verification result cache of the cell using the data verification rule in response to the modification operation of the data verification rule.
7. The method of claim 4,
and the data check formula comprises a target variable serving as a check object, wherein the target variable is a return value of a target method, and the target method is used for acquiring a cell currently subjected to data check.
8. The method of claim 1, further comprising;
and clearing the data in the fourth cell in the non-preset format in response to the first operation on the data option in the data option interface of the fourth cell.
9. The method of claim 1, further comprising:
and responding to a third operation in the fifth cell, and respectively setting a data format for at least two third data in the fifth cell, wherein the fifth cell has at least two third data.
10. The method of claim 1, further comprising:
splitting fourth data in a sixth cell into at least two fifth data in response to a fourth operation on the sixth cell;
and setting the data options of the data option interface of the fourth cell according to the at least two fifth data.
11. The method of claim 10, wherein splitting the fourth data in the sixth cell into at least two fifth data comprises:
recognizing a preset identifier in the fourth data;
and cutting the fourth data according to a preset identifier.
12. The method of claim 11, wherein prior to splitting the fourth data in the fourth cell into at least two fifth data, further comprising:
determining whether the fourth data is data of a preset type;
if the fourth data is data of a preset type, splitting the fourth data;
and if the fourth data is not the data of the preset type, not splitting the fourth data.
13. The method of claim 1, further comprising:
in response to a fifth operation on a seventh cell, merging at least two sixth data in the seventh cell into seventh data; wherein the seventh data is single-valued data;
and setting the data options of the data option interface of the seventh cell according to the seventh data.
14. The method according to claim 11, wherein the preset identifier is not allowed to exist in the data corresponding to the data option of the data option interface of any cell.
15. The method of claim 1, wherein a cell in the spreadsheet has a first attribute that identifies whether multiple data can be stored within the cell.
16. The method of claim 15, further comprising:
and in response to the fact that the first attribute of the eighth cell is changed from the storage of a plurality of data to the storage of a single data, acquiring a first data selected according to a preset sequence in the eighth cell as the data in the eighth cell.
17. An apparatus for processing a spreadsheet, comprising:
the determining unit is used for responding to first operation of at least two data options in the data option interface of the first cell and determining at least two corresponding first data; the data options are displayed in the data option interface, and the data options correspond to data;
a display unit for displaying the at least two first data in the first cell.
18. A terminal, comprising:
at least one memory and at least one processor;
wherein the at least one memory is configured to store program code and the at least one processor is configured to invoke the program code stored in the at least one memory to perform the method of any of claims 1 to 16.
19. A storage medium for storing program code for performing the method of any one of claims 1 to 16.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110171996.2A CN112905090A (en) | 2021-02-08 | 2021-02-08 | Spreadsheet processing method, device, terminal and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110171996.2A CN112905090A (en) | 2021-02-08 | 2021-02-08 | Spreadsheet processing method, device, terminal and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112905090A true CN112905090A (en) | 2021-06-04 |
Family
ID=76122734
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110171996.2A Pending CN112905090A (en) | 2021-02-08 | 2021-02-08 | Spreadsheet processing method, device, terminal and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112905090A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114254600A (en) * | 2021-11-30 | 2022-03-29 | 北京达佳互联信息技术有限公司 | Drop-down list display method, device, equipment and storage medium |
| CN114492348A (en) * | 2022-01-25 | 2022-05-13 | 北京字跳网络技术有限公司 | Information processing method, device, terminal and storage medium |
| CN115658144A (en) * | 2022-12-09 | 2023-01-31 | 西安葡萄城软件有限公司 | Spreadsheet formula on-demand calculation method and device |
| CN114254600B (en) * | 2021-11-30 | 2024-10-25 | 北京达佳互联信息技术有限公司 | Pull-down list display method, device, equipment and storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110166903A1 (en) * | 2010-01-05 | 2011-07-07 | Sunmeet Singh Jolly | Web based Offshorability Probability Calculator - Job analysis Tool for Individuals made available on Internet |
| CN108287713A (en) * | 2017-12-22 | 2018-07-17 | 深圳康得新智能显示科技有限公司 | Adding method and device, terminal, storage medium, the electronic device of document function |
| CN108351867A (en) * | 2015-11-02 | 2018-07-31 | 微软技术许可有限责任公司 | Through substantial complex data object |
| CN108352003A (en) * | 2015-11-15 | 2018-07-31 | 微软技术许可有限责任公司 | It is presented by the single choice or multiselect data of Cooperative Database service |
| CN109471694A (en) * | 2018-10-29 | 2019-03-15 | 恒生电子股份有限公司 | Drop-down list management method and drop-down list |
| CN110109918A (en) * | 2018-02-02 | 2019-08-09 | 兴业数字金融服务（上海）股份有限公司 | For verifying the method, apparatus, equipment and computer storage medium of list data |
-
2021
- 2021-02-08 CN CN202110171996.2A patent/CN112905090A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110166903A1 (en) * | 2010-01-05 | 2011-07-07 | Sunmeet Singh Jolly | Web based Offshorability Probability Calculator - Job analysis Tool for Individuals made available on Internet |
| CN108351867A (en) * | 2015-11-02 | 2018-07-31 | 微软技术许可有限责任公司 | Through substantial complex data object |
| CN108352003A (en) * | 2015-11-15 | 2018-07-31 | 微软技术许可有限责任公司 | It is presented by the single choice or multiselect data of Cooperative Database service |
| CN108287713A (en) * | 2017-12-22 | 2018-07-17 | 深圳康得新智能显示科技有限公司 | Adding method and device, terminal, storage medium, the electronic device of document function |
| CN110109918A (en) * | 2018-02-02 | 2019-08-09 | 兴业数字金融服务（上海）股份有限公司 | For verifying the method, apparatus, equipment and computer storage medium of list data |
| CN109471694A (en) * | 2018-10-29 | 2019-03-15 | 恒生电子股份有限公司 | Drop-down list management method and drop-down list |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114254600A (en) * | 2021-11-30 | 2022-03-29 | 北京达佳互联信息技术有限公司 | Drop-down list display method, device, equipment and storage medium |
| CN114254600B (en) * | 2021-11-30 | 2024-10-25 | 北京达佳互联信息技术有限公司 | Pull-down list display method, device, equipment and storage medium |
| CN114492348A (en) * | 2022-01-25 | 2022-05-13 | 北京字跳网络技术有限公司 | Information processing method, device, terminal and storage medium |
| CN115658144A (en) * | 2022-12-09 | 2023-01-31 | 西安葡萄城软件有限公司 | Spreadsheet formula on-demand calculation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110489621B (en) | Method, device, medium and electronic equipment for dynamically adjusting route | |
| CN112287206A (en) | Information processing method and device and electronic equipment | |
| CN113590974B (en) | Recommendation page configuration method and device, electronic equipment and computer readable medium | |
| CN111597107B (en) | Information output method and device and electronic equipment | |
| CN112905090A (en) | Spreadsheet processing method, device, terminal and storage medium | |
| CN111309304A (en) | Method, device, medium and electronic equipment for generating IDL file | |
| CN111857720A (en) | Method and device for generating user interface state information, electronic equipment and medium | |
| CN114428925A (en) | Page rendering method and device, electronic equipment and computer readable medium | |
| CN112256172B (en) | Application display method, device, terminal and storage medium | |
| CN111596992B (en) | Navigation bar display method and device and electronic equipment | |
| CN111262907B (en) | Service instance access method and device and electronic equipment | |
| CN111753238A (en) | Data mapping method and device and electronic equipment | |
| CN111756953A (en) | Video processing method, device, equipment and computer readable medium | |
| CN113590985B (en) | Page jump configuration method and device, electronic equipment and computer readable medium | |
| CN111737040B (en) | Program code repairing method and device | |
| CN112200643B (en) | Article information pushing method and device, electronic equipment and computer readable medium | |
| CN111628913B (en) | Online time length determining method and device, readable medium and electronic equipment | |
| CN111143355B (en) | Data processing method and device | |
| CN113807056A (en) | Method, device and equipment for correcting error of document name sequence number | |
| CN112667119A (en) | Measuring point batch correlation method and device, electronic equipment and computer readable medium | |
| CN111625692A (en) | Feature extraction method, device, electronic equipment and computer readable medium | |
| CN112084086A (en) | Information collection method, device, medium and electronic equipment | |
| CN115374320B (en) | Text matching method and device, electronic equipment and computer medium | |
| CN111857879B (en) | Data processing method, device, electronic equipment and computer readable medium | |
| CN112256346A (en) | Control display method and device and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |