In an excel file, the columns include name, age, gender, etc.
Now there are 800 pieces of data, including 20, 21, 22, 25 and so on. Now using the filter function, it is found that there are no 25 items in the drop-down list. The reason for this phenomenon may be that there are blank lines in the middle. For example, if line 600 is a blank line and does not contain any content, the filter only filters lines 1 to 600. At this time, the drop-down list only contains the age values that have appeared in the first 600 lines. After using keywords for filtering, 601-800 rows of records will also be displayed in the results. However, we found that the line numbers of the records filtered out from 1 to 600 are blue, while the line numbers from 601 to 800 are black. Therefore, the 200 lines are completely displayed there without any filtering.
Note that the blank line here means that all cells in this line have no values, or even spaces. Even if the value of only one cell in a row is a space, although it looks like a blank row, excel will not treat it as a blank row when recognizing it.
- Several methods of deleting all empty lines in text under Linux
- ValueError: not enough values to unpack (expected 2, got 0)
- [Python] pandas Library pd.to_ Parameter arrangement and example of Excel operation writing into excel file
- Git removes the content of stash
- Solution to the problem that SQL database query result field contains new line character, which leads to copy to excel dislocation
- Solutions to Excel 2007 “cannot shift object off sheet”
- Wireshark filtering HTTP packets
- Android：More than one file was found with OS independent path ‘res/values/values.xml
- Android project error Error:found an Invalid color. Solution
- Several properties of Android listview
- How to Disable Protected View in Microsoft Excel
- Pychar appears“ PEP:8 expected 2 blank lines ，found 1″
- Java 8 Stream – Read a file line by line
- Dataframe groupby custom aggregate function
- Error loading password’s fault file (MySQL for Excel)
- The solution of Hibernate query returning all null lists
- There was a problem sending the command to the program in Excel 2010
- Format control of cout cout.width () and cout.fill ()
- AE ram preview requires 2 or more frameworks to solve playback
- 【Bug-python】IndexError: list index out of range