ycphs/openxlsx issues and pull requests

#521 - Problem with deleteDataColumn

Issue - State: open - Opened by jos-no 13 days ago - 3 comments

#520 - More than one databar destroys the workbook

Issue - State: open - Opened by joshuasami 15 days ago - 2 comments

#519 - 4.2.8

Pull Request - State: closed - Opened by JanMarvin 23 days ago - 1 comment

#518 - Special Character in Sheet-Name destroys the Excel-File

Issue - State: open - Opened by joshuasami 28 days ago - 1 comment

#517 - Please clarify the development status of openxlsx, particularly with reference to openxlsx2

Issue - State: closed - Opened by hedsnz about 1 month ago - 3 comments

#516 - `writeData` to preserve the original input data types and to support 'neatly' structured lists of lists as input data structures

Issue - State: closed - Opened by olivier7121 about 2 months ago - 5 comments

#515 - fix sharedString deletion

Pull Request - State: closed - Opened by DavZim 2 months ago - 6 comments

#514 - deleteDataColumn adds strings in wrong places

Issue - State: closed - Opened by Mkranj 3 months ago - 1 comment

#513 - refactor to use cpp11?

Issue - State: closed - Opened by pachadotdev 3 months ago - 4 comments

#512 - Fix for https://github.com/ycphs/openxlsx/issues/511

Pull Request - State: closed - Opened by philaris 3 months ago - 1 comment

#511 - warning in get_worksheet_entries in an excel file that references a string in another sheet

Issue - State: closed - Opened by philaris 3 months ago

#510 - Add "centerContinuous" to the halign style property.

Issue - State: closed - Opened by egenteman 3 months ago - 2 comments

#509 - Unable to add multiple worksheets

Issue - State: closed - Opened by ABSOD 3 months ago

#508 - corrupted file if & in sheet name

Issue - State: closed - Opened by elfunesto 4 months ago - 3 comments

#507 - error in createNamedRegion

Issue - State: open - Opened by tdp-datsci 4 months ago - 1 comment

#506 - setRowHeights produces a warning when applied after setColWidths (Version 4.2.7.1), if the data.frame contains large numbers

Issue - State: closed - Opened by mkammer19 4 months ago - 1 comment

#505 - Fix the docs for setLastModifiedBy and getCreators

Pull Request - State: closed - Opened by PBfordev 5 months ago - 1 comment

#504 - Setting read.xlsx() argument detectDates = TRUE cannot run

Issue - State: closed - Opened by KimberlyHinz 5 months ago - 3 comments

#503 - Merging cells scales badly

Issue - State: open - Opened by vpetzel 5 months ago - 1 comment

#502 - Consolidate Excel File with Images and Write the Output with the Image into Excel in R

Issue - State: open - Opened by richujos 5 months ago

#501 - fix linux build on r-universe

Pull Request - State: closed - Opened by JanMarvin 5 months ago

#500 - replace std::regex which might cause issues on certain operating systems. fixes #498

Pull Request - State: closed - Opened by JanMarvin 5 months ago

#499 - Inserting hyperlinked image

Pull Request - State: closed - Opened by jistria 5 months ago - 1 comment

#498 - Version 4.2.7 detectDates not working

Issue - State: closed - Opened by tdp-datsci 5 months ago - 7 comments

#497 - Version 4.2.6 or 4.2.7 breaks reading of *.xlsm files in read.xlsx

Issue - State: closed - Opened by deschen1 5 months ago - 7 comments
Labels: waiting for answer

#496 - Update R CMD check badge

Pull Request - State: closed - Opened by Aariq 6 months ago - 1 comment

#495 - 4.2.7

Pull Request - State: closed - Opened by JanMarvin 6 months ago - 1 comment

#494 - Fix resaving workbook after resetting col widths

Pull Request - State: closed - Opened by jistria 6 months ago - 3 comments

#493 - Issue when setting col widths and saving workbook multiple times

Issue - State: closed - Opened by jistria 6 months ago

#492 - addStyle does not allow for rectangular inputs

Issue - State: open - Opened by thisCoolNerd 6 months ago - 1 comment

#491 - Column type guessing

Issue - State: open - Opened by raffaem 6 months ago - 1 comment

#490 - Replace existing worksheet

Issue - State: open - Opened by cmwakibia 6 months ago

#489 - add note

Pull Request - State: closed - Opened by JanMarvin 6 months ago

#488 - fix warning thrown in (un)groupRows. closes #485

Pull Request - State: closed - Opened by JanMarvin 7 months ago

#487 - Preserve window size and position, also get and set (Clean Version)

Pull Request - State: closed - Opened by michael-dewar 7 months ago - 1 comment

#486 - Corrupted xlsx file when a string contains \024

Issue - State: closed - Opened by Mkranj 7 months ago - 4 comments

#485 - Warning message in any(rows): “coercing argument of type 'double' to logical”

Issue - State: closed - Opened by gregmuellegger 7 months ago - 2 comments

#484 - I can't see the preview with iphone of a .xlsx file sent by email created with openxlsx

Issue - State: closed - Opened by AleTinaba93 7 months ago - 8 comments

#483 - PRs that were forgotten in development

Pull Request - State: closed - Opened by JanMarvin 7 months ago - 1 comment

#482 - silence -Wformat warning

Pull Request - State: closed - Opened by JanMarvin 7 months ago - 1 comment

#481 - [tests] fix broken skip_if_not_installed()

Pull Request - State: closed - Opened by JanMarvin 7 months ago

#480 - New CRAN error

Issue - State: closed - Opened by JanMarvin 7 months ago - 1 comment

#479 - Prepare 4.2.6

Pull Request - State: closed - Opened by JanMarvin 7 months ago

#478 - fix loading "loadExample.xlsx"

Pull Request - State: closed - Opened by JanMarvin 7 months ago

#477 - Fix cran notes

Pull Request - State: closed - Opened by JanMarvin 7 months ago

#476 - CRAN requests a new release

Issue - State: closed - Opened by JanMarvin 7 months ago - 2 comments

#475 - dataValidation can't work for character variable

Issue - State: open - Opened by Longfei2 8 months ago

#474 - Option to use R1C1 references in writeFormula()

Issue - State: open - Opened by ethan-crowell 9 months ago - 1 comment

#473 - Fix rdevel segfaults2

Pull Request - State: closed - Opened by JanMarvin 9 months ago - 1 comment

#472 - Fix rdevel segfaults

Pull Request - State: closed - Opened by JanMarvin 9 months ago - 1 comment

#471 - Can not save workbook with deleted data

Issue - State: open - Opened by cosmosByCarlSagan 9 months ago - 1 comment

#470 - write.xlsx() does not work properly with S3 class vctrs_list_of

Issue - State: open - Opened by MChiabudini 9 months ago

#469 - fails to build due to error with #include "OpenXLSX-Exports.hpp"

Issue - State: open - Opened by EmmyJamo 9 months ago

#468 - Add `pair_rc()` to improve row/column pair lookups

Pull Request - State: closed - Opened by StevenHibble-Concurrence 10 months ago - 2 comments

#467 - Speed up row/column pair lookups

Issue - State: closed - Opened by StevenHibble-Concurrence 10 months ago

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

Pull Request - State: closed - Opened by michael-dewar 10 months ago - 8 comments

#465 - Add conditionalFormatting() to seealso in createStyle() and addStyle()

Issue - State: open - Opened by phargarten2 12 months ago

#464 - Enable Total Row with writeDataTable

Issue - State: open - Opened by sch56 12 months ago

#463 - openxlsx: bad interactions between writing data tables and images

Issue - State: open - Opened by Arthfael 12 months ago

#462 - Repeated newlines are combined into one when reading XLSX on Windows

Issue - State: closed - Opened by uhkeller about 1 year ago - 2 comments
Labels: Stale

#461 - Assign Sensitivity Labels

Issue - State: open - Opened by AdamGaffney96 about 1 year ago - 6 comments

#460 - freezePane(firstActiveRow, firstActiveCol) not working as expected

Issue - State: closed - Opened by gabrielwolfson about 1 year ago - 2 comments
Labels: Stale

#459 - loadworkbook function returns error "Error in loadWorkbook(Pla_dolar, isUnzipped = TRUE) : object 'sheetrId' not found"

Issue - State: open - Opened by GustavoEAvila about 1 year ago - 2 comments

#458 - Copy style to a data

Issue - State: closed - Opened by SEvisual about 1 year ago - 1 comment
Labels: Stale

#457 - Error in write_worksheet_xml_2(prior = prior, post = post, sheet_data = ws$sheet_data, : CHAR() can only be applied to a 'CHARSXP', not a 'NULL'

Issue - State: closed - Opened by mingerman311 about 1 year ago

#456 - readWorkbook parameter 'skipEmptyCols' doesn't work as expected

Issue - State: closed - Opened by mingerman311 about 1 year ago - 2 comments
Labels: Stale

#455 - Alignment not respecting date format

Issue - State: closed - Opened by skfitzgerald over 1 year ago - 2 comments
Labels: Stale

#454 - Encodings in Column Names

Issue - State: closed - Opened by clemenskuehn over 1 year ago - 2 comments
Labels: Stale

#453 - Saving Workbook results in "Error in fill$fillFg"

Issue - State: closed - Opened by BalzH over 1 year ago - 2 comments
Labels: Stale

#452 - Ampersand in sheet name causes corruption

Issue - State: closed - Opened by cetp over 1 year ago - 2 comments
Labels: Stale

#451 - writeData( withFilter = TRUE ) fails to apply filters when opened with LibreOffice Calc

Issue - State: closed - Opened by eauleaf over 1 year ago - 2 comments
Labels: Stale

#450 - Saving HTML tables (rvest) as Excel files

Issue - State: closed - Opened by Mkranj over 1 year ago - 3 comments
Labels: Stale

#449 - Coerce matrix to data.frame in writexlsx.R

Pull Request - State: closed - Opened by grantbrown over 1 year ago

#448 - quotePrefix Property in CellFormat

Issue - State: closed - Opened by robayo over 1 year ago - 2 comments
Labels: Stale

#447 - writeDataTable to enable chunks (low memory consumption)

Issue - State: closed - Opened by surpavan over 1 year ago - 4 comments
Labels: Stale

#446 - Include an option for entering keywords in the createWorkbook function

Issue - State: closed - Opened by minifiemj over 1 year ago - 2 comments
Labels: Stale

#445 - Include ability to save workbook as an ODS file

Issue - State: closed - Opened by minifiemj over 1 year ago - 2 comments
Labels: Stale

#444 - Presence of an Excel Custom View appears to corrupt a subsequent save of the workbook

Issue - State: closed - Opened by gelisol over 1 year ago - 2 comments
Labels: Stale

#443 - Set filter choices for written data table

Issue - State: closed - Opened by jwhendy over 1 year ago - 4 comments
Labels: Stale

#442 - speed up preSaveCleanUp method for large worksheet

Pull Request - State: closed - Opened by GL-Li over 1 year ago

#441 - Add/preserve

Issue - State: closed - Opened by sisiraul over 1 year ago - 2 comments
Labels: Stale

#440 - Table with "auto" colwidths is hidden when calling openXL or saveWorkbook twice

Issue - State: closed - Opened by jey1401 over 1 year ago - 2 comments
Labels: Stale

#439 - Remove dependency on roxygen2

Pull Request - State: closed - Opened by olivroy over 1 year ago

#438 - Mildly misleading function description

Issue - State: closed - Opened by ERF4 over 1 year ago - 2 comments
Labels: Stale

#437 - Cell Styles and Conditional Formatting for Entire Row

Issue - State: closed - Opened by Busler13 over 1 year ago - 2 comments
Labels: Stale

#436 - Preserve Custom Properties when using loadWorkbook() and saveWorkbook()

Issue - State: closed - Opened by FGL-Linear over 1 year ago - 2 comments
Labels: Stale

#435 - shall we write openxlsx to word?

Issue - State: closed - Opened by yikeshu0611 over 1 year ago - 2 comments
Labels: Stale

#434 - XLSM File becomes corrupted after opening it twice and copying sheets with hyperlinks without using excel

Issue - State: closed - Opened by NieznanyImANinja over 1 year ago - 2 comments
Labels: Stale

#433 - Improve offline testing

Pull Request - State: closed - Opened by nanxstats over 1 year ago - 1 comment

#432 - `conditionalFormatting` for cells with text doesn't highlight entire row

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

#431 - If `x` is a `table` without row names, `writeData(x)` produces an extra column with weird artificial values.

Issue - State: closed - Opened by iago-pssjd over 1 year ago - 2 comments
Labels: Stale

#430 - Add ability to update a sheet in workbook without having to read the whole workbook

Issue - State: open - Opened by janlimbeck over 1 year ago - 5 comments

#429 - write.xlsx(): [Content_Types.xml] file contains reference to /xl/drawings/drawing1.xml, but not the file, which creates problems with openpyxl

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

#428 - openxlsx can not convert date/time serial numbers

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

#427 - read.xlsx can not read numbers-stored-as-text

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

#426 - select row/column on demand [has inital code]

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

#425 - colWidths = "auto" should also consider the space taken by the filter button

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

#424 - Issue with the package openxlsx

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

#423 - freezePane only works on document without previously freezed panes

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

#422 - How to apply TextDecoration from CreateStyle selectively inside a cell?

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

GitHub / ycphs/openxlsx issues and pull requests