Version History 4.1.22

Optimized Productivity Tools and Basic Experience
1.Email
Basic Capabilities
- The spell-check feature is supported. Spelling errors and grammar issues are checked, suggestions are provided, and the capitalization of the first letter of words is corrected during the composing process.
- Recipients and personalized content can be imported into emails. Different emails can be generated for different recipients. This can be used in scenarios such as interview invitations, payslips, and business emails.
- The "Subject or body" condition and the "Send to 'email group'" action is added in email receiving rules.
2.Document
Sheet
- Data can be referenced across files. You can use the IMPORTRANGE function to reference data from other sheets. The referenced data updates in real time and can be used for other calculations. This can be used in annual analysis and reports to collect and analyze data from multiple sheets.
- New chart types such as radar charts, area charts, and combination charts are added. Legends, series, coordinate axes, trend lines, and other chart elements can be customized to create professional charts.
- Hundreds of math and statistical functions such as XLOOKUP and UNIQUE are added to meet the calculation needs of various industries. Dynamic arrays are also supported to make analysis easier, where one formula can be used to calculate results in multiple cells.
- New types of data validation are added, including geographical location, email, and phone number validation. After these types are set for specific cells, users can view location and navigation information for geographical locations, send emails, and make phone calls directly from the cell through the preview page.
- Multiple links, files, and documents can be inserted into a cell.
- Diagonal borders can be set for cells. This can be used to create different types of headers.
- The import local sheet feature is optimized. More Excel properties and formats can be recognized for alignment with online sheets.
- The protected range feature is optimized. 500 members can be specified for individual permission configuration.
Smart Sheet
- Recent files can be selected to add files from the file column. Files can be searched by file name and link.
- Shortcuts such as Fn-Up Arrow, Fn-Down Arrow, and Command + Arrow keys are supported in smart sheets for easy navigation.

3.Search
- The global search window can be opened easily with a shortcut (Command + Shift + F). The shortcut can be customized in "Settings" -> "Shortcut".
- The display of "chat history" in the global search feature is optimized. Chat history can be located and context can be viewed more easily.
- The search results for "chat history" can be filtered based on "members" for more filter options.
- The speed for searching chat history in chats is optimized.
4.Calendar
- Existing events can be selected and sent in chats to share events easily.
- Participants can be selected in an event or meeting to start a group chat.

Upgraded Connect with WeChat
1.WeChat Customer Service
- Q&As recommended by bots can be added to the wiki automatically. These Q&As are recommended bots during intelligent assisted reception and are accepted by CSRs.

Optimized Security Management Abilities
1.Security Management
- Companies can view file names in the image and video leakage prevention menu after they enable "File Leakage Prevention" in "Security Management" of the Admin Console. This helps companies check file activities easily.
- Members can open restricted files they have permissions for with local applications in WeCom for PC after companies enable "File Leakage Prevention" in "Security Management" of the Admin Console.
- After setting "Prohibit Download and Export" in "File Leakage Prevention," document owners can now create document copies. Additionally, restricted documents and micro-drive files can also apply for extra download permissions.