search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
364 stars 79 forks source link

Named range names starting with numbers #553

Open cc20002002 opened 3 months ago

cc20002002 commented 3 months ago

Excel does not accept named range names starting with numbers

Openxlsx allows named range names to start with numbers. Then the saved xlsx file will lose the named range.

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)

  1. Create an empty wb object

  2. Create a named range with a name like '15000'

  3. save the object into an xlsx file then open it with excel