Comments (4)
@qrilka Thanks for the quick reply! It is not important that I have the data and pivot table in different sheets, just a matter of stylistic preference, so I will continue with them in the same sheet. You may close the issue if you want to as I will likely not have the time to work on adding support for this, or leave it open for future users to find easily.
from xlsx.
@LTibbetts so far xlsx
was supporting references to the same sheet in most of the cases, in #157 @flhorizon added some rudimentary support for cross-sheet references but I think none of usages were made aware of them.
Proper fix for this looks to require some effort (I guess we'd better make this visible on type level and not leave it to run time).
I'm not sure I will have time soon to tackle this (at work I have switched to Rust some ago) but I will be glad to help discussing/reviewing the code.
from xlsx.
I think we should leave it as something that's better be fixed, thanks
from xlsx.
Hey
I didn't look into how PivotTable are actually meant to work, and whether cross-sheet CellRef should be involved.
But regarding that error, it seems like writer accumulator functions like generateCache
should be able to access 2 cellMaps: the one of _pvtSrcSheet
and the cellMap from the sheet that contains it.
The fact there's a single _pvtSrcSheet <worksheetSource sheet="" ref=""> hints IMO the _pvtSrcRef is shaped like a local, relative ref
(looks like pivot tables references are either self->self or self->1 other).
All that to say there might be a quick win without changing the expectations about the cellref format.
I'd need to dissect a file and reads the specs though to be sure
About refining the CellRef type, I've thought a bit about them while making the tests, could be:
- an existentially quantified
SomeCellRef
+ unifying class- the class has Exception-like from/to casts and parser/writer methods
- unifying as many Typeable subtypes as configurations of cell ref (local | foreign) X (single | range)
- plus a sum type CellRefRep for a hint of what a
SomeCellRef
can be
But I digress, that's stuff for another issue
from xlsx.
Related Issues (20)
- Add search ability to Hackage page HOT 3
- Depend on microlens instead of lens? HOT 3
- NonEmpty list of worksheets HOT 3
- How to insert a row HOT 4
- Add writing support for large excell files (streaming?) HOT 10
- Writing default stylesheet to file results in excel complaining it's invalid HOT 9
- microlens flag still builds lens as a dependency
- Hyperlink Support HOT 7
- Leaking merge information across worksheets HOT 1
- Handling dates before 1900-03-01 HOT 3
- Add newtype for column and row indexes
- Add integration test that checks correctness with xlsx validator
- Support lens v5.1 HOT 5
- Hackage docs are broken HOT 9
- We shouldn't be able to make sheetnames bigger then 31 characters. HOT 1
- Cell Range dataValidation problem HOT 5
- Still applying code formatting? HOT 4
- Test files missing in sdist HOT 4
- Request: Minimal working example for styles HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from xlsx.