Ecosyste.ms: Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / ycphs/openxlsx issues and pull requests

#406 - `insertImage` and `insertPlot` unable to find image file in `R CMD check` under Linux and MacOS

Issue - State: closed - Opened by aravind-j almost 2 years ago - 2 comments
Labels: Stale

#404 - Properly closing </sheetPr> when writing `xl/worksheets/sheet*.xml`

Pull Request - State: closed - Opened by retostauffer almost 2 years ago - 1 comment

#403 - `saveWorkbook` produces invalid XML when manipulating libreoffice based XLSX files

Issue - State: closed - Opened by retostauffer almost 2 years ago - 2 comments
Labels: Stale

#402 - Introduce Warning for table col name exceeding 255 chars

Pull Request - State: closed - Opened by MKyhos almost 2 years ago - 1 comment

#401 - type "topN" and "bottomN" not working as expected in openxlsx::conditionalFormatting

Issue - State: closed - Opened by jw388743 almost 2 years ago - 2 comments
Labels: Stale

#400 - fixed typo - workbok -> workbook

Pull Request - State: closed - Opened by rpcach almost 2 years ago

#399 - loadWorkbook throws error when existing sheet in workbook contains the character ">"

Issue - State: closed - Opened by ammar-gla almost 2 years ago - 2 comments
Labels: Stale

#398 - add C++11 as a req. to `DESCRIPTION`

Pull Request - State: closed - Opened by hutch3232 almost 2 years ago - 3 comments

#397 - openxlsx won't parse Excel files with capital letter *.XLSX suffix in filename

Issue - State: closed - Opened by asapb almost 2 years ago - 7 comments
Labels: Stale

#396 - Specify C++11 as a System Requirement

Issue - State: closed - Opened by hutch3232 almost 2 years ago - 1 comment

#395 - Automatic font colour

Issue - State: closed - Opened by minifiemj almost 2 years ago - 3 comments
Labels: Stale

#394 - Import file with formula shows `&amp;` instead of `&`

Issue - State: closed - Opened by aster-hu about 2 years ago - 2 comments
Labels: Stale

#393 - Sheet-based macros are removed on Workbook save

Issue - State: closed - Opened by nicojx about 2 years ago - 5 comments
Labels: Stale

#392 - replace sprintf with snprintf

Pull Request - State: closed - Opened by JanMarvin about 2 years ago - 1 comment

#391 - writeData() results in corrupt xlsx if sheet name contains "&"

Issue - State: closed - Opened by klin333 about 2 years ago - 2 comments
Labels: Stale

#390 - Can't connect to openxlsx generated file unless I open in Excel and save it first

Issue - State: closed - Opened by rowrowrowyourboat about 2 years ago - 3 comments
Labels: Stale

#389 - Output dates formatted mm-dd-yyyy when monthly data used

Issue - State: closed - Opened by RosalynLP about 2 years ago - 2 comments

#386 - Several issues with `dataValidation(type = "list")`

Issue - State: closed - Opened by olivier7121 about 2 years ago - 16 comments
Labels: Stale

#383 - Preserve window size and position, also get and set

Pull Request - State: closed - Opened by michael-dewar about 2 years ago - 4 comments

#382 - Bugfix/fix vignette examples

Pull Request - State: closed - Opened by jmuhlenkamp about 2 years ago - 5 comments

#381 - Heading style names are lost when opening and saving xlsx file

Issue - State: closed - Opened by DIPAD-Fran-Bryden about 2 years ago - 4 comments
Labels: low priority, Stale

#379 - buildWorkbook, write.xlsx: Documentation needs to be updated

Issue - State: closed - Opened by phargarten2 over 2 years ago - 2 comments
Labels: Stale

#378 - openxlsx_setOp fails to set a style for headerStyle.

Issue - State: closed - Opened by trekonom over 2 years ago - 2 comments
Labels: Stale

#377 - Feature request: Add column to existing table

Issue - State: closed - Opened by sxl634 over 2 years ago - 2 comments
Labels: Stale

#376 - Lintr fixes

Pull Request - State: closed - Opened by JanMarvin over 2 years ago - 1 comment

#375 - Add auto row_heights feature

Pull Request - State: closed - Opened by JanMarvin over 2 years ago - 7 comments

#374 - Feature request: Add extra characters to cells based on other criteria

Issue - State: closed - Opened by rempsyc over 2 years ago - 3 comments
Labels: Stale

#372 - writeDataTable() not constructed as error suggests

Issue - State: closed - Opened by millermc38 over 2 years ago - 3 comments
Labels: Stale

#370 - Opening a wb object that was loaded from xlsx causes content problems

Issue - State: closed - Opened by jzadra over 2 years ago - 11 comments
Labels: fixed, Stale

#368 - Percentage format not working

Issue - State: closed - Opened by tkpmep over 2 years ago - 9 comments
Labels: bug, Stale

#367 - use "auto" for setRowheights

Issue - State: closed - Opened by David-Rattray over 2 years ago - 16 comments
Labels: Stale

#362 - Default date formatting

Issue - State: closed - Opened by lz1nwm over 2 years ago - 14 comments
Labels: fixed, Stale

#359 - How to prevent "NA" strings when saving workbooks

Issue - State: closed - Opened by deschen1 over 2 years ago - 13 comments
Labels: Stale

#356 - A method to return the 'used extent' on a worksheet

Issue - State: closed - Opened by sch56 over 2 years ago - 3 comments
Labels: Stale

#355 - saveWorkbook() changing format of empty cells below data

Issue - State: closed - Opened by victorrssx over 2 years ago - 3 comments
Labels: Stale

#354 - conditionalFormatting does not take numFmt

Issue - State: closed - Opened by klar-C over 2 years ago - 5 comments
Labels: bug, Stale

#352 - Adding @ for formulas

Issue - State: closed - Opened by klar-C over 2 years ago - 6 comments

#351 - addition of more than one conditionalFormatting() function corrupts the Excel file

Issue - State: closed - Opened by omertayyab over 2 years ago - 7 comments
Labels: bug, Style issue, Stale

#344 - Error reading .xlsx Workbook has no worksheets

Issue - State: closed - Opened by Matpli over 2 years ago - 10 comments
Labels: enhancement, help wanted, low priority, Stale

#342 - Warning in `dataValidation(type = "list")`

Issue - State: closed - Opened by tentacles-from-outer-space over 2 years ago - 8 comments
Labels: fixed, Stale

#341 - Feature Request: Merge repeated cells by one or more variables

Pull Request - State: closed - Opened by darentsai over 2 years ago - 7 comments
Labels: Stale

#340 - protectWorkbook & protectWorksheet do not work

Issue - State: closed - Opened by wphampton over 2 years ago - 13 comments
Labels: Stale

#338 - read.xlsx namedRegion field

Issue - State: closed - Opened by jasongu809 over 2 years ago - 1 comment
Labels: bug, Stale

#337 - Deleting the only sheet from a Workbook and creating it again, corrupts the Excel file

Issue - State: closed - Opened by deschen1 over 2 years ago - 2 comments
Labels: bug, Stale

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

Issue - State: closed - Opened by michael-m52 over 2 years ago - 16 comments
Labels: bug, good first issue, fixed, Stale

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

Issue - State: closed - Opened by michael-m52 over 2 years ago - 14 comments
Labels: bug, good first issue, Style issue, Stale

#333 - Files should be written according to default ACLs

Issue - State: closed - Opened by finalspy over 2 years ago - 15 comments
Labels: fixed, Stale

#332 - createWorkbook "Created" date is offset by timezone difference

Issue - State: closed - Opened by michael-m52 over 2 years ago - 5 comments
Labels: bug, fixed, Stale

#330 - writeData with a date messes up existing cell styles (numFmt)

Issue - State: closed - Opened by kainhofer almost 3 years ago - 3 comments
Labels: bug, good first issue, fixed, Style issue, Stale

#329 - Headers and Footers: NA to skip position comes out as string literal "NA" in actual Header/Footer

Issue - State: closed - Opened by michael-m52 almost 3 years ago - 2 comments
Labels: bug, documentation, Style issue, Stale

#327 - databarExample.xlsx example compiles, but cannot be opened

Issue - State: closed - Opened by badgettrg almost 3 years ago - 2 comments
Labels: Stale

#326 - Convert a range to a number

Issue - State: closed - Opened by klar-C almost 3 years ago - 20 comments
Labels: enhancement, low priority, Stale

#325 - type = 'blanks' option not available for conditionalFormatting()

Issue - State: closed - Opened by amanda-hi almost 3 years ago - 4 comments
Labels: fixed, Stale

#323 - Excel output has non-standard column widths

Issue - State: closed - Opened by xIncubakerx almost 3 years ago - 15 comments
Labels: bug, Style issue, low priority, Stale

#321 - deleteData doesn't delete styles even though help function says so

Issue - State: closed - Opened by deschen1 almost 3 years ago - 3 comments
Labels: Stale

#320 - Copying workbooks and performing changes on the copy destroys/applies the changes also to the original

Issue - State: closed - Opened by deschen1 almost 3 years ago - 2 comments
Labels: Stale

#319 - feature request: allow "format painter" functionality

Issue - State: closed - Opened by deschen1 almost 3 years ago - 5 comments
Labels: Stale

#318 - fillMergedCells fails in NamedRegions

Issue - State: closed - Opened by Skepe almost 3 years ago - 2 comments
Labels: Stale

#317 - Use class `workbookFormula` rather than `formula`

Issue - State: closed - Opened by jmbarbone almost 3 years ago - 2 comments
Labels: Stale

#316 - Do not allow `NA` as column name

Pull Request - State: open - Opened by jmbarbone almost 3 years ago - 5 comments
Labels: Stale

#315 - adds `as.character.formula()`

Pull Request - State: closed - Opened by jmbarbone almost 3 years ago - 2 comments
Labels: Stale

#314 - saving workbook twice causes issues with setColWidths

Issue - State: closed - Opened by JanMarvin almost 3 years ago - 7 comments
Labels: bug, Stale

#313 - Excel fail to open the output created from openxlsx with slicer

Issue - State: closed - Opened by radiance88 almost 3 years ago - 5 comments
Labels: Stale

#312 - write formula fails when formula.tools package is loaded

Issue - State: closed - Opened by klin333 almost 3 years ago - 10 comments
Labels: Stale

#309 - Gh issue 307

Pull Request - State: closed - Opened by JanMarvin almost 3 years ago - 2 comments

#307 - read.xlsx() does not return the correct number of rows

Issue - State: open - Opened by daattali almost 3 years ago - 9 comments

#302 - fix warning in extLinksXML. closes #293

Pull Request - State: closed - Opened by JanMarvin about 3 years ago - 2 comments
Labels: question, Stale

#301 - Cleanup references to drawing and vmlDrawing. If the workbook does no…

Pull Request - State: closed - Opened by JanMarvin about 3 years ago - 3 comments
Labels: WIP

#299 - Add excel dataTable examples to writeFormula()

Issue - State: closed - Opened by zykezero about 3 years ago - 6 comments
Labels: documentation, Stale

#294 - Multiple groupRows?

Issue - State: closed - Opened by bfreed3 about 3 years ago - 4 comments
Labels: fixed, Stale

#293 - Invalid format string in loadWorkbook

Issue - State: closed - Opened by tlapak about 3 years ago - 3 comments
Labels: Stale

#292 - Corrupt Excel file when column name is `NA`

Issue - State: closed - Opened by bersbersbers about 3 years ago - 5 comments
Labels: bug, Stale

#291 - Improve detectDates. closes #288

Pull Request - State: closed - Opened by JanMarvin about 3 years ago - 4 comments

#288 - `read.xlsx(detectDates = TRUE)` failing

Issue - State: closed - Opened by jmbarbone about 3 years ago - 10 comments

#285 - tag in [Content_Types] refers to empty drawing, triggering error in OpenXml

Issue - State: closed - Opened by acobolew about 3 years ago - 6 comments
Labels: good first issue, Stale

#281 - openxlsx.numFmt changes date format

Issue - State: closed - Opened by joshuaschwab about 3 years ago - 5 comments
Labels: Stale

#280 - Formatting Attributes Applied to Entire Columns not Carrying Over to Saved Workbook

Issue - State: closed - Opened by mendy-friedman about 3 years ago - 5 comments
Labels: Stale

#261 - Reading in file with formula shows values as 0 (unless the original file is opened in Excel and saved)

Issue - State: closed - Opened by deschen1 about 3 years ago - 10 comments
Labels: Stale

#254 - Loading/Saving empty sheets or sheets with "&" in their name

Issue - State: closed - Opened by mictru about 3 years ago - 4 comments
Labels: Stale

#253 - What does printerSettings do?

Issue - State: closed - Opened by JanMarvin about 3 years ago - 2 comments
Labels: Stale

#247 - Updates for new release

Pull Request - State: closed - Opened by ycphs over 3 years ago - 9 comments

#245 - Uploaded template formatting is not preserved upon export

Issue - State: closed - Opened by drsjp31 over 3 years ago - 6 comments
Labels: good first issue, fixed, waiting for answer, Stale

#241 - fix for empty workbooks

Pull Request - State: closed - Opened by ycphs over 3 years ago - 1 comment

#239 - Update R-CMD-check.yaml

Pull Request - State: closed - Opened by ycphs over 3 years ago - 2 comments

#235 - Feature Request - function to set Print area for multipage sheet

Issue - State: closed - Opened by AlvaroMCMC over 3 years ago - 7 comments
Labels: enhancement, low priority, Stale

#233 - Dependency reduction

Pull Request - State: closed - Opened by ycphs over 3 years ago

#231 - xlsx file created with openxlsx can't be opened in SPSS

Issue - State: closed - Opened by deschen1 over 3 years ago - 28 comments
Labels: 3rd party issue, Stale

#230 - Outline settings

Issue - State: closed - Opened by klar-C over 3 years ago - 12 comments
Labels: fixed, Stale

#227 - No data found on worksheet

Issue - State: closed - Opened by vchouraki over 3 years ago - 14 comments
Labels: Stale

#222 - move image to img directory

Pull Request - State: closed - Opened by ycphs over 3 years ago

#220 - check revdep only not for PR

Pull Request - State: closed - Opened by ycphs over 3 years ago

#214 - unicode escape for shared strings

Pull Request - State: closed - Opened by ycphs over 3 years ago - 9 comments

#213 - check for illegal sheetnames

Pull Request - State: open - Opened by ycphs over 3 years ago - 6 comments
Labels: Stale

#211 - openxlsx allows invalid characters in worksheet names

Issue - State: closed - Opened by jonas-hag over 3 years ago - 4 comments
Labels: fixed, waiting for answer, Stale

#207 - loadWorkbook removing formatting

Issue - State: closed - Opened by mdorchuckuva over 3 years ago - 34 comments
Labels: bug, waiting for answer, Style issue