Skip to content
This repository has been archived by the owner on Mar 9, 2020. It is now read-only.

Workhseet name prepended to series #548

Open
alexb5dh opened this issue Sep 13, 2019 · 0 comments
Open

Workhseet name prepended to series #548

alexb5dh opened this issue Sep 13, 2019 · 0 comments

Comments

@alexb5dh
Copy link

Worksheet names are appended to series formula in all cases. This leads to formula errors in case of static values list. For example {1,2,3} gets translated to 'worksheet_name'!{1,2,3}.

I see this handled in ExcelChartSerie.Series setter via call to ExcelCellBase.GetFullAddress. My suggestion is to make this prepending optional or add a way to set formula directly.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant