search

Swechhya / excelR

An Interface to 'jExcel.js' Library
https://swechhya.github.io/excelR/
Other
152 stars 19 forks source link

autofill = FALSE does not work? #92

Closed daeyoonlee closed 3 years ago

daeyoonlee commented 3 years ago

Describe the bug I want to copy all the numbers to the same value, but I don't know how. Even with autofill = FALSE, if you grab the dot at the bottom right and lower it, the value will automatically increase.

image

To Reproduce

library(excelR)

data = data.frame(Model = c(10,"","",""), Date=c('2006-01-01', '2005-01-01','2004-01-01', '2003-01-01' ), Availability = c(TRUE, FALSE, TRUE, TRUE))

columns = data.frame(title=c('Model', 'Date', 'Availability'), width= c(300, 300, 300), type=c('text', 'calendar', 'checkbox'))

excelTable(data=data, autoFill = FALSE, columns = columns)

Expected behavior If autofill = FALSE, no auto increment.

Desktop (please complete the following information):

Swechhya commented 3 years ago

@daeyoonlee You need to set the autoIncrement parameter to FALSE. The excelTable function would look like this: excelTable(data=data, autoFill = FALSE, columns = columns, autoIncrement = FALSE)

Closing this issue, feel free to open it again if this does not resolve your issue.