michael-m52 comments

Results 10 comments of


                                            michael-m52

createWorkbook "Created" date is offset by timezone difference

This works perfectly in the development branch

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

Hi @JanMarvin, thanks so much for you efforts. So your suggestion means that we would pass the display text into the hyperlink class object as "name" when creating it with...

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

Hi @JanMarvin, on further reflection, I am wondering what the Excel application does to those hyperlinks when you "Save A Copy", because after this step, the hyperlinks are perfectly readable...

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

Thanks @JanMarvin I understand these are not high priority issues and I'll try fixing some things myself. I'm not confident with GitHub but I'll attempt a pull request if I...

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

Thanks @JanMarvin Is there a way to create an internal hyperlink using openxlsx without using the HYPERLINK formula? In VBA it would look like this: ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= "Sheet2!A1",...

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

Thankyou, I have a workaround now that uses writeData instead.

michael-m52

createWorkbook "Created" date is offset by timezone difference

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

writeFormula with HYPERLINK creates unparseable XML: read.xlsx doesn't read "Text to display" from a file created by openxlsx

loadWorkbook does not retain Headers and Footers that have "escape code" formatting

loadWorkbook does not retain Headers and Footers that have "escape code" formatting

loadWorkbook does not retain Headers and Footers that have "escape code" formatting

Already configured Improv BLE device discovery reappears after HA restart