'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Checkboxes Changing to Boolean Values When Exporting to PDF
Question details
The user needs to convert an Excel spreadsheet containing checkboxes to a PDF document without losing the visual checkbox formatting during the process.
- Product
- Microsoft Excel / OneDrive Connector
- Device & OS
- not provided
- Scenario
- Automating or converting Excel files to PDF format using the OneDrive Convert File connector.
- Observed behavior
- The visual checkboxes are replaced by textual Boolean values (e.g., TRUE or FALSE) in the resulting PDF file instead of maintaining their graphical appearance.
Ensure your Excel file is saved locally to your device before attempting alternative PDF conversion methods. Check if the checkboxes were created using traditional Form Controls or the newer cell checkbox feature, as this can affect how they render during automated conversions.
Use Excel's Manual PDF Export Feature
Bypassing the OneDrive connector and manually exporting from the Excel desktop application ensures that visual formatting, including new checkbox controls, is preserved.
The OneDrive Convert File connector relies on a background rendering engine that may not yet support the latest Excel features. Using the native export feature forces Excel to render the file exactly as it appears on your screen.
Open the Excel file containing your checkboxes in the desktop application rather than Excel for the Web.
Click on 'File' in the top-left corner of the ribbon and select 'Export' from the side menu.
Click the 'Create PDF/XPS Document' button to open the publishing dialog box.
Choose your desired save location, click 'Publish', and open the resulting PDF to verify the checkboxes are displayed correctly.
Print to PDF Using System Printers
Using the 'Print to PDF' function forces the system to capture a direct graphical snapshot of what is displayed on the screen.
Convert Spreadsheets to PDF Without Losing Formatting in WPS Office
WPS Spreadsheet offers a built-in, highly accurate PDF converter that preserves all visual elements, including form controls and modern checkboxes, ensuring your final document looks exactly as intended without relying on external cloud connectors.
- 1. Open your Excel file: Launch WPS Office and click on 'Open' to load your Excel (.xlsx) file containing the checkboxes.
- 2. Verify formatting: Review your spreadsheet within the WPS interface to ensure your checkboxes appear correctly.
- 3. Access the Export tool: Navigate to the 'Tools' tab on the top ribbon and click on the 'Export to PDF' button.
- 4. Adjust export settings: In the dialog box, configure your export settings, such as the page range and output layout.
- 5. Generate the PDF: Click 'Export' to save the file. Open the newly created PDF to confirm your checkboxes are visually preserved.
Frequently Asked Questions
Why does the OneDrive Convert File connector change checkboxes to TRUE/FALSE text?
The OneDrive Convert File connector relies on a background conversion engine that may not yet fully support rendering newer Excel cell checkbox controls. As a fallback, it extracts and displays the underlying data values (TRUE for checked, FALSE for unchecked) instead of drawing the visual box.
Can I fix the OneDrive connector to keep my visual checkboxes?
Currently, there is no direct configuration setting to fix this within the connector itself. Microsoft needs to update the backend rendering engine. Until then, you must use alternative methods like manual export or third-party automation tools.
Are Developer Form Control checkboxes affected by this PDF conversion issue?
This issue typically affects the newer, built-in cell checkboxes in Excel. Traditional checkboxes created via the Developer tab (Form Controls or ActiveX controls) are treated as floating graphical elements and are usually rendered correctly during cloud conversions.
Will my checkboxes work interactively in the exported PDF?
No, standard PDF exports from Excel convert checkboxes into static images representing their current state. If you need fillable, clickable checkboxes in a PDF document, you will need to create a dedicated PDF form using professional PDF editing software.
