Pandas version checks

• [X] I have checked that the issue still exists on the latest versions of the docs on main here

Location of the documentation

IO tools OpenDocument spreadsheets Version 1.5.2 (stable)

Documentation problem

The good news of support in pandas for writing OpenDocument spreadsheets has not propagated from the 'dev' branch of the documentation to applicable documentation versions, i.e from 1.1.0 onwards.

There is a dependency on the odfpy package, as mentioned here: https://stackoverflow.com/questions/58915626/write-dataframe-into-ods-format

I checked the functionality with pandas version 1.5.2 after manually installing odfpy, and it works like a snap.

The documentation for version 1.5.2 states:

! Note Currently pandas only supports reading OpenDocument spreadsheets. Writing is not implemented.

The documentation for dev states:

! New in version 1.1.0. Similarly, the to_excel() method can write OpenDocument spreadsheets

```

Writes DataFrame to a .ods file

df.to_excel("path_to_file.ods", engine="odf") ```

There is no mention of the dependency on odfpy.

Suggested fix for documentation

! New in version 1.1.0. Similarly, the to_excel() method can write OpenDocument spreadsheets

# Writes DataFrame to a .ods file
df.to_excel("path_to_file.ods", engine="odf")

This functionality depends on the odfpy package, which needs to be installed manyally with e.g. pip for the time being.

Comment From: phofl

Hi, thanks for your report. This is fixed on the current version of our docs (dev).

Sorry for the close: I thought the last sentence was from the docs as well. PRs to add this welcome

Comment From: luke396

take