When generating the calculation report in SW6-2024 version, a reminder is given to install Office; have there been any cases where it was possible to generate the report successfully using WPS? How to operate it?

I have encountered this problem as well; SW6 indeed relies heavily on Office when generating calculation reports. I’ve tried WPS; some versions work, but errors occur frequently, especially when it comes to VBA macros or specific templates. It is recommended that you first verify whether the “VBA for WPS” component is properly installed in WPS (some simplified versions do not have it); SW6 typically needs to use Office macros to generate calculation reports. If that still doesn’t work, you can try running WPS in compatibility mode, or manually set the default document generator in the SW6 system settings to point to WPS’s executable file. The safest approach is to install Microsoft Office, even the free versions from 2007 or 2010 (make sure to get it from a reliable source); this way, compatibility issues are virtually unlikely. If you insist on using WPS, the specific steps may vary depending on the versions of SW6 and WPS. It is recommended that you search for forum threads titled “SW6 WPS for generating calculation sheets”, where more detailed instructions can be found.

I fully understand the poster’s needs; using WPS as a substitute for Office to create calculation sheets is indeed a necessity for many people. What the fellow mentioned earlier regarding registering VBA components and removing residual files from Office is also very important. I’d like to add two more practical points: In WPS settings, the file association needs to be confirmed manually. After installing WPS, it’s recommended to open WPS’s “Configuration Tools” (usually found in the WPS folder on the Start menu), locate “Advanced” or “Compatibility Settings”, and manually select file types such as“.xlsx/.docx” for association. When SW6 generates calculation reports, if WPS is not the default office software associated with the system, it may fail to call WPS or generate an error. If the error persists, you can try installing WPS’s VBA component package: some streamlined or green versions of WPS may not come with a VBA runtime, which will cause VBA calls in SW6 to fail. You can download the standalone package “WPS VBA for WPS” from the WPS official website or community for installation, which can resolve many compatibility issues. Additionally, if the account owner has limited permissions as an internal network user or system administrator, it is possible to try running SW6 as an administrator; sometimes insufficient permissions can also prevent the use of WPS components. If all of the above attempts fail, it is recommended to install a free trial version of Office 2019/2021 specifically for generating calculation sheets, as SW6 indeed offers more stable VBA compatibility with Office. Hope this helps the original poster!

It claims to support WPS, but in reality, WPS Enterprise is required; there are issues with support for the free personal version of WPS.