John McNamara
John McNamara
Since I've had a few requests about this I've added a note about making donations to prioritize this feature.
Since I've had a few requests about this I've added a note about making donations to prioritize this feature.
@jeroen Just getting to this now. > is there something like worksheet_write_formula_num for hyperlinks so that LibreOffice can display them correctly ? I could add a `worksheet_write_formula_str()` function to add...
@jeroen Can I make the suggestion once more that hyperlinks should be converted using the `worksheet_write_url()` function and not as a `=HYPERLINK()` formula. There are a few benefits to this:...
> Which makes me think that the problematic point may be the writexl::write_xlsx(myfile_edited) (?) That seems logical. On the other hand the libxlsxwriter library used by writxl is designed (and...
@erosix any update on this?
@jeroen could you close this issue since there is no reproducible example.
That's a good suggestion. I'll look into it.
Libxlsxwriter takes the infamous Excel 1900 leap year into account but writxl does a direct date conversion (for performance I guess) and get bitten by it for dates before 1900-03-01....
I've pushed a fix in #59. Here is a small working example: ```R > df > writexl::write_xlsx(df, 'datetimes.xlsx') > > readxl::read_xlsx('datetimes.xlsx') # A tibble: 4 x 3 dates numbers check...