tidyxl

tidyxl copied to clipboard

Hidden columns sometimes cause R session to crash with calling tidyxl::xlsx_cells()

1

Using `test.xlsx` I can reproduce an R session crash every time: ```r tidyxl::xlsx_cells(path = "test.xlsx") ``` [test.xlsx](https://github.com/nacnudus/tidyxl/files/9143227/test.xlsx) If I unhide column "B", the R session does not crash. Using `test2.xlsx`,...

gacolitti

Optionally apply merged cells across their range

21

E.g. if a cell with value "foo" is merged across `A1:A2` then cell `A2` should be created/overridden as a clone.

nacnudus

special characters in file path

2

Hello, `xlsx_cells` is not able to read a file when there are special characters (as "é" in french) in its path. Here is a reproducible example : ```r library(tidyxl) examples

py-b

Investigate #82 by creating a test that will be run on Windows. I can't reproduce the error on my own Linux device.

nacnudus

Identifying pivot tables in sheets

1

Perhaps I'm missing something, but it would be great to be able to identify a pivot table within a sheet. It appears that the cell formatting of cells in the...

sch56

Import hyperlinks

1

ECMA page 1641 ```xml ``` `_rels/sheet1.xml.rels` ```xml ```

nacnudus

Formulas referring to other files

2

Forgive my noobyness... the readme refers to "the roadmap for tidyxl includes de-referencing such numbers". I'm struggling to understand where the "roadmap" is in the github documents. I'm working on...

RavenCEF

Can you make R Makevars specify gcc? ipcc fails.

9

Hello, I noticed that the Intel compiler barfs on your package when trying to link with piton. ``` icpc -std=gnu++11 -I"/opt/R/R-4.0.2-mkl/lib64/R/include" -DNDEBUG -I'/home/me/R/lib/pro/4.0/Rcpp/include' -I'/home/me/R/lib/pro/4.0/piton/include' -I/usr/local/include -fpic -g -O2 -c xlex.cpp...

wdkrnls

Hex badge

2

A package this good needs a hex!

jl5000

Unable to extract conditional formatting using xlsx_formats

5

I am unable to extract conditional formatting from an xlsx file using xlsx_formats. The goal is to continuously rebuild a xlsx file using openxslx, but I want to maintain the...

awdursun