The legal validity rule of WPS table name naming

When a table defines a name, many people are prompted to "enter an invalid name" "Name is not valid" and the definition is unsuccessful. This is because, when defining a name, not any character can be a name, the definition of a name has certain rules.

1. A name can be any character combined with a number, but it cannot begin with a number, or a number as a name, such as 1PL. Also, the name cannot be the same as the cell address, such as B3.

If you want to start with a number, you can precede it with an underscore, such as _1PL.

2. You cannot use the letters R, C, R, and C as names, because R, C represents the rows and columns of the worksheet in the R1C1 reference style.

3. The name cannot contain spaces, and can be replaced with an underscore or point number.

4. You cannot use symbols other than underscores, dots, and backslashes (/) to allow a question mark (?), but not as the beginning of a name, such as tkw? tkw.

5. The name character cannot exceed 255 characters. In general, the name should be easy to remember and be as short as possible, otherwise it would violate the original intention of defining the name.

6. The letters in the name are not case-sensitive.

In addition, there are some special-meaning names that are automatically defined by a table after users use such advanced production filtering features. Here are two practical special names, Print_titles and Print_Area.

The area defined as Print_titles will be the top heading row and the left-end header row of the print for the current worksheet. For example, the 1:1 definition name for a worksheet is "Print_titles", and the worksheet prints the line on each page when it is printed. The area defined as Print_Area is set to the print area of the worksheet for the related content that defines the top header row and the left-side header row for printing.