---
title: "Discussion on \"openpyxl Returns None for Formula Cells: Excel Calculates, openpyxl Only Reads the Cache\" | Hashnode"
description: "Discussion on \"openpyxl Returns None for Formula Cells: Excel Calculates, openpyxl Only Reads the Cache\". Why data_only=True gives None, how saving destroys formulas, and how to force a real recalculation with LibreOffice headless."
url: "https://hashnode.com/posts/openpyxl-returns-none-for-formula-cells-excel-calculates-openpyxl-only-reads-the-cache/6afd3a00ebcc0b38d6184745"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [openpyxl Returns None for Formula Cells: Excel Calculates, openpyxl Only Reads the Cache](https://ankitkhoiwal.hashnode.dev/openpyxl-returns-none-for-formula-cells-excel-calculates-openpyxl-only-reads-the-cache?utm_source=hashnode&utm_medium=feed)

Why data\_only=True gives None, how saving destroys formulas, and how to force a real recalculation with LibreOffice headless.

21h ago · 6 min read · ankitkhoiwal.hashnode.dev  
Read the article

-   [#python](https://hashnode.com/tag/python)
-   [#excel](https://hashnode.com/tag/excel)
-   [#openpyxl](https://hashnode.com/tag/openpyxl)
-   [#automation](https://hashnode.com/tag/automation)

## Written by

[Blogs World](https://hashnode.com/@blogs-world)

@blogs-world

  
[View profile](https://hashnode.com/@blogs-world)

Beyond the code, a story

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
