wwyws0000

conditionalformatting() with "databar" type creates a corrupted excel file when used more than once

9

## Expected Behavior Ideally, I want to use openxlsx to create multiple instances of databars using conditionalFormatting() in a single sheet. The attached file is a simple example with two...

writeFormula adding an "@" symbol between formulas

2

Hi, I'm trying to write a formula to the spreadsheet that takes the sum of absolute values of a range (say, cell A2:A11). I.e, the desired formula is SUM(ABS(A2:A11)) ##...