Update log
v1.0.7.20190411_Release
1. Add a user-defined culling feature column, and you can add or delete it as needed;
2. Optimize the main program.
v1.0.6.20190402_Release
Conditional print settings
v1.0.5.20190402_Release
The new feature columns are "year-end bonus" and "year-end bonus tax".
v1.0.4.20190402_Release
Add dynamic naming rules for worksheet names.
v1.0.3.20190401_Release
Add a dialog box prompt after the completion of Adjust Payroll Format.
v1.0.2.20190329_Release
Supplement the "precautions" that may cause errors, and provide solutions.
v1.0.1.20190328_Release
Keep the words "Reviewed by Human Resources Department" consistent with the original form.
Download instructions
Updated to 1.0.7 on April 11, 2019
1. The download file is: Payroll-format-correction-master.zip
2. After decompression, we get: V1.0.7 Payroll Format Batch Corrector.rar
3. Decompress V1.0.7 Payroll Format Batch Corrector.rar
obtain V1.0.7 Payroll format batch corrector
Folder to use.
Function introduction
It is used for batch correction of payroll format. Its main functions are as follows:
1. Delete blank lines, blank columns and unnecessary feature columns;
2. Adaptive data lines, add total amount;
3. Hide zero value;
4. Adaptive cell column width;
5. Self adaptively print one page of A3 paper.
Instructions&Precautions
1. Support Microsoft Office 2003, 2007, etc. (the compact version is not available), and WPS Office needs to enable development tools;
2. Click first when using Batch Import Payroll
Button. After importing, click Adjust Payroll Format
Button;
3. If the error "Cannot set the.... Property of PageSetup class" occurs during running, you need to add a printer driver in the "Printer" option of the control panel. You can add a printer or a virtual printer;
4. In order to avoid secondary adjustment, please remove the payroll after format correction in time and save it separately. It will not be stored in the corrector;
5. The corrector will not modify the original data, but the salary data is more important, so the user still needs to proofread by himself.
The figure shows the v1.0.6 interface
enclosure
File name: Payroll format batch corrector
Current version: v 1.0.7
Decompress password: For internal use, please contact the author