CN112784551A - Method, device and equipment for realizing cell and picture adaptation - Google Patents

Method, device and equipment for realizing cell and picture adaptation Download PDF

Info

Publication number
CN112784551A
CN112784551A CN202010473274.8A CN202010473274A CN112784551A CN 112784551 A CN112784551 A CN 112784551A CN 202010473274 A CN202010473274 A CN 202010473274A CN 112784551 A CN112784551 A CN 112784551A
Authority
CN
China
Prior art keywords
target
picture
target picture
cell
array
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
CN202010473274.8A
Other languages
Chinese (zh)
Inventor
陈志宝
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.)
Zhuhai Kingsoft Office Software Co Ltd
Guangzhou Kingsoft Mobile Technology Co Ltd
Original Assignee
Zhuhai Kingsoft Office Software Co Ltd
Guangzhou Kingsoft Mobile Technology Co Ltd
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 Zhuhai Kingsoft Office Software Co Ltd, Guangzhou Kingsoft Mobile Technology Co Ltd filed Critical Zhuhai Kingsoft Office Software Co Ltd
Priority to CN202010473274.8A priority Critical patent/CN112784551A/en
Publication of CN112784551A publication Critical patent/CN112784551A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The application provides a method, a device and equipment for realizing cell and picture adaptation, which are applied to the technical field of computers. The method for realizing the cell and picture adaptation comprises the following steps: determining a plurality of target pictures to be adapted from a worksheet; constructing an array containing the width of the target picture and the column number of the target cell corresponding to the target picture; constructing an array comprising the height of the target picture and the line number of the target cell corresponding to the target picture; dividing each first array containing the same column number into the same group, and dividing each second array containing the same row number into the same group; determining the adaptation width of the target column based on the maximum width contained in each first array in the first group, and adjusting the column width of the target column to the adaptation width; and determining the adaptive height of the target row based on the maximum height contained in each second array in the second grouping, and adjusting the row height of the target row to the adaptive height. The efficiency of inserting pictures by the user can be improved.

Description

Method, device and equipment for realizing cell and picture adaptation
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, an apparatus, and a device for implementing cell and picture adaptation.
Background
When using form office software, it is sometimes necessary to prepare a picture for the data in the form. After a user inserts a picture into the table, since the size of the inserted picture is different from the size of the cell, in order to enable the picture to be displayed completely in the cell, that is, the picture is adapted to the cell, adaptation processing about the cell and the picture is required.
At present, the process for implementing cell and picture adaptation is as follows: the user needs to manually adjust the width of the column to which the picture belongs according to the width of the picture, and manually adjust the height of the row to which the picture belongs according to the height of the picture.
It can be seen that this manual adjustment makes the picture insertion very inefficient, requiring a lot of time for the user.
Disclosure of Invention
An object of the embodiments of the present application is to provide a method, an apparatus, and a device for implementing cell and picture adaptation, so as to solve the problem of low picture insertion efficiency caused by manually adjusting a cell to adapt to a picture in the prior art. The specific technical scheme is as follows:
in a first aspect, an embodiment of the present application provides a method for implementing cell and picture adaptation, including:
determining a plurality of target pictures to be adapted from a worksheet;
for each target picture, constructing an array containing the width of the target picture and the column number of a target cell corresponding to the target picture, and using the array as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the target picture is the cell in which the upper left corner of the target picture is located;
dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group;
for each first group, determining the adaptive width of a target column based on the maximum width contained in each first array in the first group, and adjusting the column width of the target column to the adaptive width; wherein, the target column is a column with a column number contained in each first array in the first group;
for each second group, determining the adaptation height of a target row based on the maximum height contained in each second array in the second group, and adjusting the row height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group.
Optionally, the determining a plurality of target pictures to be adapted from the worksheet includes:
determining a cell area in a selected state currently in a worksheet;
traversing each picture in the worksheet, and judging whether the cell in which the upper left corner of each picture is located is in the cell area; if so, the picture is determined as the target picture.
Optionally, the determining, for each first packet, an adapted width of the target column based on a maximum width included in each first array in the first packet includes:
for each first group, determining the adaptive width of the target column based on the maximum width contained in each first array in the first group and the reserved distance of the first frame; the reserved first frame distance is an expected distance value between the target picture with the maximum width and the opposite boundary of the corresponding target cell in the width direction;
for each second group, determining the adaptation height of the target row based on the maximum height contained in each second array in the second group includes:
for each second group, determining the adaptive height of the target row based on the maximum height contained in each second array in the second group and the reserved distance of the second frame; the reserved distance of the second frame is an expected distance value between the target picture with the maximum height and the opposite boundary of the corresponding target cell in the height direction;
after adjusting the column width of each target column and the row height of each target row, the method further comprises:
for each target picture, determining position adjustment data of the target picture according to the line height and the line width of a cell where the target picture is located and the vertex coordinates of the upper left corner of the cell where the target picture is located; and moving the target picture to a position corresponding to the position adjustment data.
Optionally, the determining, for each target picture, position adjustment data of the target picture according to the row height and the column width of the cell in which the target picture is located and the vertex coordinates of the upper left corner of the cell in which the target picture is located includes:
for each target picture, calculating the abscissa of the position adjustment data of the target picture according to a first preset formula, and calculating the ordinate of the position adjustment data of the target picture according to a second preset formula to obtain the position adjustment data of the target picture; wherein,
the first predetermined formula includes:
Figure BDA0002515014430000031
the second predetermined formula includes:
Figure BDA0002515014430000032
wherein, PxAdjusting the abscissa, P, of the data for the position of the target pictureyAdjusting the ordinate, P, of the data for the position of the target picturewIs the width, P, of the target picturehFor the height of the target picture, TCwIs the column width, TC, of the cell in which the target picture is locatedhIs the height, TC, of the cell in which the target picture is positionedxIs the abscissa, TC, of the vertex at the upper left corner of the cell in which the target picture is positionedyAnd the vertical coordinate of the top left corner vertex of the cell where the target picture is located.
In a second aspect, an embodiment of the present application provides an apparatus for implementing cell and picture adaptation, including:
the picture determining module is used for determining a plurality of target pictures to be adapted from the worksheet;
the array construction module is used for constructing an array containing the width of the target picture and the column number of the target cell corresponding to the target picture as a first array of the target picture aiming at each target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the target picture is the cell in which the upper left corner of the target picture is located;
the data grouping module is used for dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group;
the width adjusting module is used for determining the adaptation width of a target column based on the maximum width contained in each first array in each first grouping and adjusting the column width of the target column to the adaptation width; wherein, the target column is a column with a column number contained in each first array in the first group;
the height adjusting module is used for determining the adaptation height of a target row according to the maximum height contained in each second array in each second group and adjusting the height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group.
Optionally, the picture determining module includes:
the first determining submodule is used for determining the cell area in the selected state currently in the worksheet;
the second determining submodule is used for traversing each picture in the worksheet and judging whether a target cell corresponding to each picture is in the cell area or not; if so, the picture is determined as the target picture.
Optionally, the width adjustment module includes:
the first adjusting submodule is used for determining the adaptation width of the target column according to the maximum width contained in each first array in each first grouping and the reserved distance of the first frame aiming at each first grouping; the reserved first frame distance is an expected distance value between the target picture with the maximum width and the opposite boundary of the corresponding target cell in the width direction;
the height adjustment module includes:
the second adjusting submodule is used for determining the adaptation height of the target row according to the maximum height contained in each second array in each second group and the second frame reserved distance aiming at each second group; the reserved distance of the second frame is an expected distance value between the target picture with the maximum height and the opposite boundary of the corresponding target cell in the height direction;
the device further comprises:
the position adjusting module is used for determining position adjusting data of each target picture according to the row height and the column width of a unit cell where the target picture is located and the vertex coordinates of the upper left corner of the unit cell where the target picture is located aiming at each target picture after the width adjusting module and the height adjusting module respectively adjust the column width of each target column and the row height of each target row; and moving the target picture to a position corresponding to the position adjustment data.
Optionally, the position adjusting module is specifically configured to:
for each target picture, calculating the abscissa of the position adjustment data of the target picture according to a first preset formula, and calculating the ordinate of the position adjustment data of the target picture according to a second preset formula to obtain the position adjustment data of the target picture; wherein,
the first predetermined formula includes:
Figure BDA0002515014430000051
the second predetermined formula includes:
Figure BDA0002515014430000052
wherein, PxAdjusting the abscissa, P, of the data for the position of the target pictureyAdjusting the ordinate, P, of the data for the position of the target picturewIs the width, P, of the target picturehFor the height of the target picture, TCwIs the column width, TC, of the cell in which the target picture is locatedhIs the height, TC, of the cell in which the target picture is positionedxIs the abscissa, TC, of the vertex at the upper left corner of the cell in which the target picture is positionedyAnd the vertical coordinate of the top left corner vertex of the cell where the target picture is located.
In a third aspect, an embodiment of the present application provides an electronic device, including a processor, a communication interface, a memory, and a communication bus, where the processor and the communication interface complete communication between the memory and the processor through the communication bus;
a memory for storing a computer program;
and the processor is used for realizing the steps of the method for realizing the adaptation of the cell and the picture provided by the embodiment of the application when executing the program stored in the memory.
In a fourth aspect, the present application provides a computer-readable storage medium, in which a computer program is stored, and when the computer program is executed by a processor, the computer program implements the steps of the method for implementing cell and picture adaptation provided by the embodiment of the present application.
The embodiment of the application has the following beneficial effects:
the method provided by the embodiment of the application determines a plurality of target pictures to be adapted from a worksheet; for each target picture, constructing an array containing the width of the target picture and the column number of a target cell corresponding to the target picture, and using the array as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the picture is the cell in which the upper left corner of the target picture is positioned; dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group; for each first group, determining the adaptive width of a target column based on the maximum width contained in each first array in the first group, and adjusting the column width of the target column to the adaptive width; wherein, the target column is a column with a column number contained in each first array in the first group; for each second group, determining the adaptation height of a target row based on the maximum height contained in each second array in the second group, and adjusting the row height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group. Therefore, the method and the device can realize that the width of the cell can be automatically adjusted to be the width of the widest picture in the same column, the height of the cell can be adjusted to be the height of the highest picture in the same row, the size of the cell does not need to be manually adjusted by a user, and therefore the efficiency of inserting the picture by the user can be greatly improved.
Of course, not all advantages described above need to be achieved at the same time in the practice of any one product or method of the present application.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of a method for implementing cell and picture adaptation according to the present application;
FIG. 2 is another flowchart of a method for adapting a cell to a picture according to the present application;
FIG. 3 is a schematic structural diagram of an apparatus for implementing cell and picture adaptation according to the present application;
FIG. 4 is another structural diagram of an apparatus for implementing cell and picture adaptation according to the present application;
fig. 5 is a schematic structural diagram of an electronic device according to the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
In order to solve the problem of the prior art, embodiments of the present application provide a method, an apparatus, and a device for implementing cell and picture adaptation, so as to improve efficiency of inserting a picture for a user.
First, a method for implementing cell and picture adaptation provided by the embodiment of the present application is described below.
The method for realizing adaptation of the cell and the picture provided by the embodiment of the application can be applied to electronic equipment. In a specific application, the electronic device may be: the device comprises a smart phone, a tablet computer, a notebook computer, a desktop computer and the like, wherein the smart phone, the tablet computer, the notebook computer, the desktop computer and the like can run table office software.
In addition, the functional software for implementing the method for adapting the cell to the picture can be: a functional plug-in embedded into existing forms office software. Certainly, the functional software for implementing the method for adapting the cell to the picture may also be: and special form office software, which can add new software with cell and picture adapting function to the existing form office software.
In addition, the form office software according to the embodiment of the present application may be any software that takes a spreadsheet as a processing object, for example: execl spreadsheet software, wps spreadsheet software, and the like. Wherein the execl form software is spreadsheet processing software in the Microsoft flag, and the wps form software is spreadsheet processing software in the Jinshan flag.
As shown in fig. 1, a method for implementing cell and picture adaptation provided in an embodiment of the present application may include the following steps:
s101, determining a plurality of target pictures to be adapted from a worksheet;
the target picture to be adapted is a picture which needs to be completely displayed in the cell.
The implementation of determining the plurality of target pictures to be adapted from the worksheet may be various.
For example, in one implementation, determining a plurality of target pictures to be adapted may include: and inquiring all the pictures in the worksheet, and taking all the pictures as target pictures to be adapted.
In this implementation manner, a full selection button may be provided in the function menu of the worksheet, and all pictures in the worksheet may be used as target pictures through the full selection button, so as to obtain a plurality of target pictures to be adapted.
For example, in another implementation, determining a plurality of target pictures to be adapted may include:
determining a cell area in a selected state currently in a worksheet;
traversing each picture in the worksheet, and judging whether the cell in which the upper left corner of each picture is located is in the cell area; if so, the picture is determined as the target picture.
In this implementation, the user may perform adaptation analysis processing on a part of the pictures in the worksheet by selecting the cell region.
In particular, determining the cell regions in the worksheet that are currently in the selected state may be accomplished using known techniques. It should be noted that, traversing each picture in the worksheet, and determining whether the cell in which the upper left corner of each picture is located is in the cell area may include: and determining whether the picture is positioned in the currently selected cell area or not according to the cell vertex coordinate at which the upper left corner of each picture is positioned, and the height, the width and the vertex coordinate of the cell area currently in the selected state. The vertex coordinates are vertex coordinates of the upper left corner, but the vertex coordinates are not limited to these, and may also be vertex position coordinates of the upper right corner, for example.
It can be understood that, after a plurality of target pictures to be adapted are determined, the attribute information included in the target pictures can be acquired according to the functions existing in the worksheet. When the attribute information contained in the target picture needs to be used, the attribute information can be obtained in a direct calling mode. The attribute information included in the target picture may include: the width and height of the target picture, and the coordinates of each vertex of the target picture.
S102, aiming at each target picture, constructing an array comprising the width of the target picture and the column number of a target cell corresponding to the target picture, and using the array as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture as a second array of the target picture;
and the target cell corresponding to the target picture is the cell in which the upper left corner of the target picture is positioned. It can be understood that, after a plurality of target pictures to be adapted in the worksheet are determined, acquiring the target cells corresponding to the target pictures can be implemented by using the prior art. And the target cell corresponding to each target picture is the cell that needs to be adapted to the target picture, that is, each target picture needs to be completely displayed in the corresponding target cell.
In addition, the attribute information contained in the target cell corresponding to each target picture can be acquired by adopting the existing function in the worksheet; the attribute information of the target cell may include: the target cell is located in the worksheet at the row and column number.
S103, dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group;
in order to facilitate simultaneous adjustment of a plurality of target cells with the same row or column number, the plurality of first arrays and the plurality of second arrays that are constructed may be grouped: and dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group. It is understood that the column numbers contained in each first group are the same after the first groups are grouped, and the row numbers contained in each second group are the same after the second groups are grouped.
S104, aiming at each first group, determining the adaptive width of a target column based on the maximum width contained in each first array in the first group, and adjusting the column width of the target column to the adaptive width;
to reduce the time it takes for a user to manually adjust the column width of the cells to fit the width of the target picture, the fit width of the target column may be determined for each first grouping. The target column is a column having a column number included in each first array in the first group, and the adaptive width is a width that enables the maximum width included in each first array in the second group, the width of the corresponding target picture, and the full display to be achieved.
And aiming at each first group, the adaptation width required by each first array in the first group is not less than the maximum width contained by each first array. It should be noted that, for each first group, there are various specific implementation manners for determining the adaptation width of the target column based on the maximum width included in each first array in the first group.
For example, in an implementation manner, for each first packet, determining an adapted width of the target column based on a maximum width included in each first array in the first packet may include:
and aiming at each first group, taking the maximum width contained in each first array in the first group as the adaptive width of the target column.
For example, in an implementation manner, for each first packet, determining an adapted width of the target column based on a maximum width included in each first array in the first packet may include:
and amplifying the maximum width contained in each first array in each first group by a preset multiple aiming at each first group to obtain a preset width, and taking the preset width as an adaptive width, wherein the preset multiple is a number greater than 1.
For clarity of the scheme and clarity of layout, in the following description, with reference to specific embodiments, other specific implementations of determining the adaptation width of the target column based on the maximum width included in each first array in each first group for each first group are described in detail.
S105, aiming at each second group, determining the adaptation height of a target row based on the maximum height contained in each second array in the second group, and adjusting the row height of the target row to be the adaptation height;
to reduce the time it takes for the user to manually adjust the row height of the cells to fit the height of the target picture, the fit height of the target row may be determined for each second grouping. It should be noted that the target row has a row with a row number included in each second array in the second group; the adapted height is a height which enables the maximum height contained in each second array in the second group, the height of the corresponding target picture and the complete display.
For each second group, the adaptation height required by each second group in the second group is not less than the maximum height contained by each second group; it should be noted that, for each second grouping, there are various specific implementation manners for determining the adaptation height of the target row based on the maximum height included in each second array in the second grouping.
For example, in one implementation, for each second group, determining the adapted height of the target row based on the maximum height included in each second array in the second group may include:
and regarding each second group, taking the maximum height contained in each second array in the second group as the adaptive height of the target row.
For example, in one implementation, for each second group, determining the adapted height of the target row based on the maximum height included in each second array in the second group may include:
and amplifying the maximum height contained in each second array in each second sub-group by a preset multiple to obtain a preset height, and taking the preset height as an adaptive height, wherein the preset multiple is a number greater than 1.
For clarity of the scheme and layout, further specific implementation manners for determining the adaptation height of the target row based on the maximum height included in each second array in each second group for each second group are described in detail later with reference to specific embodiments.
In addition, it should be noted that there may be a plurality of execution sequences of S104 and S105, for example: s104 and S105 may be executed in parallel; or, executing S104 and then executing S105; alternatively, S105 is performed first and then S104 is performed.
In the embodiment of the application, a plurality of target pictures to be adapted are determined from a worksheet; for each target picture, constructing an array containing the width of the target picture and the column number of a target cell corresponding to the target picture, and using the array as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the picture is the cell in which the upper left corner of the target picture is positioned; dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group; for each first group, determining the adaptive width of a target column based on the maximum width contained in each first array in the first group, and adjusting the column width of the target column to the adaptive width; wherein, the target column is a column with a column number contained in each first array in the first group; for each second group, determining the adaptation height of a target row based on the maximum height contained in each second array in the second group, and adjusting the row height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group. Therefore, the method and the device can realize that the width of the cell can be automatically adjusted to be the width of the widest picture in the same column, the height of the cell can be adjusted to be the height of the highest picture in the same row, the size of the cell does not need to be manually adjusted by a user, and therefore the efficiency of inserting the picture by the user can be greatly improved.
A method for implementing cell and picture adaptation provided by the embodiments of the present application is described below with reference to specific embodiments.
The method for realizing adaptation of the cell and the picture provided by the embodiment of the application can be applied to electronic equipment. In a specific application, the electronic device may be: the device comprises a smart phone, a tablet computer, a notebook computer, a desktop computer and the like, wherein the smart phone, the tablet computer, the notebook computer, the desktop computer and the like can run table office software.
In addition, for the functional software for implementing the method for adapting the cell to the picture and the related description and explanation content of the table office software related to the embodiment of the present application, reference may be made to the corresponding content of the above embodiment, which is not described herein again.
As shown in fig. 2, a method for implementing cell and picture adaptation provided in an embodiment of the present application may include the following steps:
s201, determining a plurality of target pictures to be adapted from a worksheet;
s202, aiming at each target picture, constructing an array comprising the width of the target picture and the column number of a target cell corresponding to the target picture, and using the array as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture;
s203, dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group;
in this embodiment, S201 to S203 are the same as S101 to S103 in the above embodiment, and are not described herein again.
S204, aiming at each first group, determining the adaptive width of a target column based on the maximum width contained in each first array in the first group and the reserved distance of a first frame, and adjusting the column width of the target column to the adaptive width;
and the reserved first frame distance is an expected distance value between the target picture with the maximum width and the opposite boundary of the corresponding target cell in the width direction. Specifically, the first margin is a desired distance value between the left and right boundaries of the target picture having the maximum width and the left and right boundaries of the corresponding target cell.
Since the reserved first bounding box distance has an influence on determining the adaptation width of the target column, for each first group, the adaptation width of the target column may be determined based on the maximum width included in each first array in the first group and the reserved bounding box distance.
Illustratively, for each first group, the sum of the maximum width contained in each first array in the first group and twice the reserved distance of the border is used as the adaptive width of the target column.
S205, for each second group, determining the adaptive height of a target row based on the maximum height and the second frame reserved distance contained in each second array in the second group, and adjusting the row height of the target row to the adaptive height;
the reserved distance of the second frame is an expected distance value between the target picture with the maximum height and the opposite boundary of the corresponding target cell in the height direction; specifically, the second frame reserved distance is an expected distance value between the upper and lower boundaries of the target picture with the maximum height and the upper and lower boundaries of the corresponding target cell.
Since the second frame reserved distance has an influence on determining the adaptation height of the target row, for each second packet, the adaptation height of the target row may be determined based on the maximum height included in each second array in the second packet and the frame reserved distance.
For each second group, the sum of the maximum height contained in each second array in the second group and twice the reserved distance of the frame is taken as the adaptive height of the target row.
It should be noted that the execution sequence of S204 and S205 may include: executing S204 and S205 simultaneously; or, first execute S204, then execute S205; or: s205 is executed first, and then S204 is executed, which is not limited herein.
In this embodiment, in order to further improve user experience, each target picture may be displayed in the target cell corresponding to the target picture in a centered manner and has a certain distance from the frame of the cell, and at this time, the target cell may be adapted to the corresponding target picture based on the first frame reserved distance and the second frame reserved distance. It can be understood that there are many implementations of obtaining the border first frame reserved distance and the second frame reserved distance. For example, in one implementation, the user triggers pop-up of a prompt box for inputting the first frame reserved distance and the second frame reserved distance by clicking the target picture, so that the user can input the distance values to be reserved, namely the first frame reserved distance and the second frame reserved distance, in the input area of the prompt box. For convenience of user operation, the operation of triggering the prompt box to pop up by clicking the picture may not be limited to the operation of double-clicking the picture.
Illustratively, in another implementation manner, an icon for popping up the prompt box is provided in the function menu area in the worksheet in advance, the user can pop up the prompt box by clicking the icon, and then the user inputs the first frame reserved distance and the second frame reserved distance in the prompt box. The first frame reserved distance and the second frame reserved distance input in the mode can be reserved as user setting information so as to be suitable for the processing process of any target picture in each worksheet in the functional software.
It can be understood that, for convenience of operation, when the prompt box for inputting the first frame reserved distance and the second frame reserved distance by the user pops up, the input area may display a default distance value to be reserved, and the user changes the first frame reserved distance value and the second frame reserved distance value by clicking the input area. In addition, the values of the first frame reserved distance and the second frame reserved distance may be set to 0 or not 0, and the values of the first frame reserved distance and the second frame reserved distance may be set to the same distance value or different distance values, so that the user may set the distance values according to the actual setting. The shape, size and specific position of the above-mentioned prompt box in the worksheet are set according to the characteristics of the worksheet, and are not limited herein.
S206, aiming at each target picture, determining position adjustment data of the target picture according to the line height and the line width of the cell where the target picture is located and the vertex coordinates of the upper left corner of the cell where the target picture is located; moving the target picture to a position corresponding to the position adjustment data;
for example, in an implementation manner, for each target picture, determining position adjustment data of the target picture according to a line height and a line width of a cell in which the target picture is located and a vertex coordinate of an upper left corner of the cell in which the target picture is located may include:
for each target picture, calculating the abscissa of the position adjustment data according to a first predetermined formula, and calculating the ordinate of the position adjustment data according to a second predetermined formula to obtain the position adjustment data;
the first predetermined formula includes:
Figure BDA0002515014430000141
the second predetermined formula includes:
Figure BDA0002515014430000142
wherein, PxAdjusting the abscissa, P, of the data for the position of the target pictureyAdjusting the ordinate, P, of the data for the position of the target picturewIs the width, P, of the target picturehTo the targetHeight of picture, TCwIs the column width, TC, of the cell in which the target picture is locatedhIs the height, TC, of the cell in which the target picture is positionedxIs the abscissa, TC, of the vertex at the upper left corner of the cell in which the target picture is positionedyAnd the vertical coordinate of the top left corner vertex of the cell where the target picture is located.
Of course, it is not limited to this manner.
In the embodiment of the application, a plurality of target pictures to be adapted are determined from a worksheet; for each target picture, constructing an array containing the width of the target picture and the column number of a target cell corresponding to the target picture, and using the array as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the picture is the cell in which the upper left corner of the target picture is positioned; dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group; for each first group, determining the adaptive width of a target column based on the maximum width contained in each first array in the first group, and adjusting the column width of the target column to the adaptive width; wherein, the target column is a column with a column number contained in each first array in the first group; for each second group, determining the adaptation height of a target row based on the maximum height contained in each second array in the second group, and adjusting the row height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group. Therefore, the method and the device can realize that the width of the cell can be automatically adjusted to be the width of the widest picture in the same column, the height of the cell can be adjusted to be the height of the highest picture in the same row, the size of the cell does not need to be manually adjusted by a user, and therefore the efficiency of inserting the picture by the user can be greatly improved. In addition, the client can set the reserved frame distance, so that the display of the target picture more meets the display requirement of the user on the picture, and the use experience of the user is improved.
With respect to the foregoing method embodiment, an apparatus for implementing cell and picture adaptation is provided in the present application, and as shown in fig. 3, the apparatus may include:
a picture determination module 310, configured to determine a plurality of target pictures to be adapted from the worksheet;
an array construction module 320, configured to construct, for each target picture, an array including a width of the target picture and a column number of a target cell corresponding to the target picture, as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the picture is the cell in which the upper left corner of the target picture is positioned;
the data grouping module 330 is configured to divide each first array including the same column number into the same group to obtain at least one first group, and divide each second array including the same row number into the same group to obtain at least one second group;
a width adjustment module 340, configured to determine, for each first packet, an adaptation width of a target column based on a maximum width included in each first array in the first packet, and adjust a column width of the target column to the adaptation width; wherein, the target column is a column with a column number contained in each first array in the first group;
a height adjusting module 350, configured to determine, for each second group, an adaptation height of a target row based on a maximum height included in each second array in the second group, and adjust a row height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group.
In the embodiment of the application, a plurality of target pictures to be adapted are determined from a worksheet; for each target picture, constructing an array containing the width of the target picture and the column number of a target cell corresponding to the target picture, and using the array as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the picture is the cell in which the upper left corner of the target picture is positioned; dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group; for each first group, determining the adaptive width of a target column based on the maximum width contained in each first array in the first group, and adjusting the column width of the target column to the adaptive width; wherein, the target column is a column with a column number contained in each first array in the first group; for each second group, determining the adaptation height of a target row based on the maximum height contained in each second array in the second group, and adjusting the row height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group. Therefore, the method and the device can realize that the width of the cell can be automatically adjusted to be the width of the widest picture in the same column, the height of the cell can be adjusted to be the height of the highest picture in the same row, the size of the cell does not need to be manually adjusted by a user, and therefore the efficiency of inserting the picture by the user can be greatly improved.
Optionally, the picture determining module 310 includes:
the first determining submodule is used for determining the cell area in the selected state currently in the worksheet;
the second determining submodule is used for traversing each picture in the worksheet and judging whether a target cell corresponding to each picture is in the cell area or not; if so, the picture is determined as the target picture.
Optionally, the width adjusting module 340 includes:
the first adjusting submodule is used for determining the adaptive width of the target column according to the maximum width contained in each first array in each first group and the reserved frame distance for each first group;
the height adjustment module 350 includes:
the second adjusting submodule is used for determining the adaptation height of the target row according to the maximum height contained in each second array in each second group and the frame reserved distance aiming at each second group;
correspondingly, on the basis of the image determining module 310, the array constructing module 320, the data grouping module 330, the width adjusting module 340 and the height adjusting module 350, the apparatus for implementing cell and image adaptation provided by the embodiment of the present application, as shown in fig. 4, may further include:
a position adjusting module 360, configured to, after the width adjusting module 340 and the height adjusting module 350 respectively adjust the column width of each target column and the row height of each target row, determine, for each target picture, position adjustment data of the target picture according to the row height and the column width of the cell in which the target picture is located, and the vertex coordinate of the upper left corner of the cell in which the target picture is located; and moving the target picture to a position corresponding to the position adjustment data.
Optionally, the position adjusting module 360 is specifically configured to:
for each target picture, calculating the abscissa of the position adjustment data of the target picture according to a first preset formula, and calculating the ordinate of the position adjustment data of the target picture according to a second preset formula to obtain the position adjustment data of the target picture; wherein,
the first predetermined formula includes:
Figure BDA0002515014430000171
the second predetermined formula includes:
Figure BDA0002515014430000172
wherein, PxAdjusting the abscissa, P, of the data for the position of the target pictureyAdjusting the ordinate, P, of the data for the position of the target picturewIs the width, P, of the target picturehFor the height of the target picture, TCwTo the targetColumn width of cell, TC, in which picture is locatedhIs the height, TC, of the cell in which the target picture is positionedxIs the abscissa, TC, of the vertex at the upper left corner of the cell in which the target picture is positionedyAnd the vertical coordinate of the top left corner vertex of the cell where the target picture is located.
The embodiment of the present application further provides an electronic device, as shown in fig. 5, which includes a processor 501, a communication interface 502, a memory 503 and a communication bus 504, wherein the processor 501, the communication interface 502 and the memory 503 complete mutual communication through the communication bus 504,
a memory 503 for storing a computer program;
the processor 501 is configured to implement the steps of the method for implementing cell and picture adaptation provided in the embodiment of the present application when executing the program stored in the memory 503.
The communication bus mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus.
The communication interface is used for communication between the electronic equipment and other equipment.
The Memory may include a Random Access Memory (RAM) or a Non-Volatile Memory (NVM), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the processor.
The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components.
In a further embodiment provided by the present application, there is further provided a computer-readable storage medium having a computer program stored therein, where the computer program, when executed by a processor, implements the steps of any of the above-mentioned methods for implementing cell and picture adaptation.
In another embodiment provided by the present application, there is also provided a computer program product containing instructions, which when run on a computer, causes the computer to execute any one of the above-mentioned methods for implementing cell and picture adaptation.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, cause the processes or functions described in accordance with the embodiments of the application to occur, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website site, computer, server, or data center to another website site, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that incorporates one or more of the available media. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for embodiments of devices, apparatuses, storage media, etc., since they are substantially similar to the method embodiments, the description is relatively simple, and reference may be made to some descriptions of the method embodiments for relevant points.
The above description is only for the preferred embodiment of the present application and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application are included in the protection scope of the present application.

Claims (10)

1. A method for adapting a cell to a picture, comprising:
determining a plurality of target pictures to be adapted from a worksheet;
for each target picture, constructing an array containing the width of the target picture and the column number of a target cell corresponding to the target picture, and using the array as a first array of the target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the target picture is the cell in which the upper left corner of the target picture is located;
dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group;
for each first group, determining the adaptive width of a target column based on the maximum width contained in each first array in the first group, and adjusting the column width of the target column to the adaptive width; wherein, the target column is a column with a column number contained in each first array in the first group;
for each second group, determining the adaptation height of a target row based on the maximum height contained in each second array in the second group, and adjusting the row height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group.
2. The method of claim 1, wherein determining a plurality of target pictures to be adapted from a worksheet comprises:
determining a cell area in a selected state currently in a worksheet;
traversing each picture in the worksheet, and judging whether the cell in which the upper left corner of each picture is located is in the cell area; if so, the picture is determined as the target picture.
3. The method according to claim 1 or 2,
for each first group, determining the adaptive width of the target column based on the maximum width included in each first array in the first group includes:
for each first group, determining the adaptive width of the target column based on the maximum width contained in each first array in the first group and the reserved distance of the first frame; the reserved first frame distance is an expected distance value between the target picture with the maximum width and the opposite boundary of the corresponding target cell in the width direction;
for each second group, determining the adaptation height of the target row based on the maximum height contained in each second array in the second group includes:
for each second group, determining the adaptive height of the target row based on the maximum height contained in each second array in the second group and the reserved distance of the second frame; the reserved distance of the second frame is an expected distance value between the target picture with the maximum height and the opposite boundary of the corresponding target cell in the height direction;
after adjusting the column width of each target column and the row height of each target row, the method further comprises:
for each target picture, determining position adjustment data of the target picture according to the line height and the line width of a cell where the target picture is located and the vertex coordinates of the upper left corner of the cell where the target picture is located; and moving the target picture to a position corresponding to the position adjustment data.
4. The method of claim 3, wherein the determining the position adjustment data of each target picture according to the row height and the column width of the cell where the target picture is located and the vertex coordinates of the upper left corner of the cell where the target picture is located comprises:
for each target picture, calculating the abscissa of the position adjustment data of the target picture according to a first preset formula, and calculating the ordinate of the position adjustment data of the target picture according to a second preset formula to obtain the position adjustment data of the target picture; wherein,
the first predetermined formula includes:
Figure FDA0002515014420000021
the second predetermined formula includes:
Figure FDA0002515014420000022
wherein, PxAdjusting the abscissa, P, of the data for the position of the target pictureyAdjusting the ordinate, P, of the data for the position of the target picturewIs the width, P, of the target picturehFor the height of the target picture, TCwIs the column width, TC, of the cell in which the target picture is locatedhIs the height, TC, of the cell in which the target picture is positionedxIs the abscissa, TC, of the vertex at the upper left corner of the cell in which the target picture is positionedyAnd the vertical coordinate of the top left corner vertex of the cell where the target picture is located.
5. An apparatus for adapting a cell to a picture, comprising:
the picture determining module is used for determining a plurality of target pictures to be adapted from the worksheet;
the array construction module is used for constructing an array containing the width of the target picture and the column number of the target cell corresponding to the target picture as a first array of the target picture aiming at each target picture; constructing an array containing the height of the target picture and the row number of the target cell corresponding to the target picture, and using the array as a second array of the target picture; the target cell corresponding to the target picture is the cell in which the upper left corner of the target picture is located;
the data grouping module is used for dividing each first array containing the same column number into the same group to obtain at least one first group, and dividing each second array containing the same row number into the same group to obtain at least one second group;
the width adjusting module is used for determining the adaptation width of a target column based on the maximum width contained in each first array in each first grouping and adjusting the column width of the target column to the adaptation width; wherein, the target column is a column with a column number contained in each first array in the first group;
the height adjusting module is used for determining the adaptation height of a target row according to the maximum height contained in each second array in each second group and adjusting the height of the target row to the adaptation height; wherein the target row has rows with row numbers included in each second array in the second group.
6. The apparatus of claim 5, wherein the picture determination module comprises:
the first determining submodule is used for determining the cell area in the selected state currently in the worksheet;
the second determining submodule is used for traversing each picture in the worksheet and judging whether a target cell corresponding to each picture is in the cell area or not; if so, the picture is determined as the target picture.
7. The apparatus of claim 5 or 6,
the width adjustment module includes:
the first adjusting submodule is used for determining the adaptation width of the target column according to the maximum width contained in each first array in each first grouping and the reserved distance of the first frame aiming at each first grouping; the reserved first frame distance is an expected distance value between the target picture with the maximum width and the opposite boundary of the corresponding target cell in the width direction;
the height adjustment module includes:
the second adjusting submodule is used for determining the adaptation height of the target row according to the maximum height contained in each second array in each second group and the second frame reserved distance aiming at each second group; the reserved distance of the second frame is an expected distance value between the target picture with the maximum height and the opposite boundary of the corresponding target cell in the height direction;
the device further comprises:
the position adjusting module is used for determining position adjusting data of each target picture according to the row height and the column width of a unit cell where the target picture is located and the vertex coordinates of the upper left corner of the unit cell where the target picture is located aiming at each target picture after the width adjusting module and the height adjusting module respectively adjust the column width of each target column and the row height of each target row; and moving the target picture to a position corresponding to the position adjustment data.
8. The apparatus of claim 7, wherein the position adjustment module is specifically configured to:
for each target picture, calculating the abscissa of the position adjustment data of the target picture according to a first preset formula, and calculating the ordinate of the position adjustment data of the target picture according to a second preset formula to obtain the position adjustment data of the target picture; wherein,
the first predetermined formula includes:
Figure FDA0002515014420000041
the second predetermined formula includes:
Figure FDA0002515014420000042
wherein, PxAdjusting the abscissa, P, of the data for the position of the target pictureyAdjusting the ordinate, P, of the data for the position of the target picturewIs the width, P, of the target picturehFor the height of the target picture, TCwIs the column width, TC, of the cell in which the target picture is locatedhIs the height, TC, of the cell in which the target picture is positionedxIs the abscissa, TC, of the vertex at the upper left corner of the cell in which the target picture is positionedyAnd the vertical coordinate of the top left corner vertex of the cell where the target picture is located.
9. An electronic device is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor and the communication interface are used for realizing mutual communication by the memory through the communication bus;
a memory for storing a computer program;
a processor for implementing the method steps of any of claims 1 to 4 when executing a program stored in the memory.
10. A computer-readable storage medium, characterized in that a computer program is stored in the computer-readable storage medium, which computer program, when being executed by a processor, carries out the steps of the method according to any one of claims 1-4.
CN202010473274.8A 2020-05-29 2020-05-29 Method, device and equipment for realizing cell and picture adaptation Pending CN112784551A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010473274.8A CN112784551A (en) 2020-05-29 2020-05-29 Method, device and equipment for realizing cell and picture adaptation

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010473274.8A CN112784551A (en) 2020-05-29 2020-05-29 Method, device and equipment for realizing cell and picture adaptation

Publications (1)

Publication Number Publication Date
CN112784551A true CN112784551A (en) 2021-05-11

Family

ID=75749142

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010473274.8A Pending CN112784551A (en) 2020-05-29 2020-05-29 Method, device and equipment for realizing cell and picture adaptation

Country Status (1)

Country Link
CN (1) CN112784551A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113204557A (en) * 2021-05-21 2021-08-03 北京字跳网络技术有限公司 Electronic form importing method, device, equipment and medium
CN113962193A (en) * 2021-11-15 2022-01-21 北京金山办公软件股份有限公司 Table typesetting method and device, electronic equipment and storage medium

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2015096634A1 (en) * 2013-12-23 2015-07-02 北京金山办公软件有限公司 Tabular file display method and system
US20170124040A1 (en) * 2015-11-02 2017-05-04 Microsoft Technology Licensing, Llc Images associated with cells in spreadsheets

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2015096634A1 (en) * 2013-12-23 2015-07-02 北京金山办公软件有限公司 Tabular file display method and system
US20170124040A1 (en) * 2015-11-02 2017-05-04 Microsoft Technology Licensing, Llc Images associated with cells in spreadsheets

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113204557A (en) * 2021-05-21 2021-08-03 北京字跳网络技术有限公司 Electronic form importing method, device, equipment and medium
CN113204557B (en) * 2021-05-21 2024-02-13 北京字跳网络技术有限公司 Electronic form importing method, device, equipment and medium
US12086126B2 (en) 2021-05-21 2024-09-10 Beijing Zitiao Network Technology Co., Ltd. Method, device and apparatus for spreadsheet importing, and medium
CN113962193A (en) * 2021-11-15 2022-01-21 北京金山办公软件股份有限公司 Table typesetting method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
CN109753641B (en) Method and device for changing object position, electronic equipment and storage medium
CN112784551A (en) Method, device and equipment for realizing cell and picture adaptation
EP2874054B1 (en) Application text adjusting method, device, and terminal
CN113190781A (en) Page layout method, device, equipment and storage medium
CN114579912A (en) Page layout method, device, equipment and medium
CN115357155A (en) Window identification method, device, equipment and computer readable storage medium
CN111698548B (en) Video playing method and device
CN117519682A (en) Component layout method, device, computer equipment and storage medium
CN112329409B (en) Cell color conversion method and device and electronic equipment
WO2018205812A1 (en) Picture presentation method and device
CN107807755B (en) Adjust the method and device of touch-control block size on display panel
CN111881050B (en) Text layer cutting method and device and electronic equipment
CN112232046B (en) Method and device for displaying repeated items of table
CN112784543A (en) Picture adjusting method, device, equipment and storage medium
CN112417832A (en) Format conversion method and device for spreadsheet document and electronic equipment
CN112882775A (en) Method and device for self-adaptive adjustment of page template
CN112784526A (en) Document page adjusting method and device
CN112487769B (en) Cell background generation method and device
CN112233202B (en) Regular polygon drawing method and device, electronic equipment and readable storage medium
WO2024000111A1 (en) Desktop display method, electronic device, display apparatus and computer-readable storage medium
CN111767700A (en) Graph adjusting method and device
CN111696169A (en) Method and device for generating equilateral polygon and electronic equipment
CN110209690B (en) Data acquisition method and device and electronic equipment
CN111832267B (en) Cell pasting method and device
US20230128155A1 (en) Icon arrangement method, user terminal and storage medium

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