Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Use filtering instead of hard hiding rows #5

Closed
zhuj opened this issue Dec 10, 2016 · 2 comments
Closed

Use filtering instead of hard hiding rows #5

zhuj opened this issue Dec 10, 2016 · 2 comments
Assignees

Comments

@zhuj
Copy link
Owner

zhuj commented Dec 10, 2016

It's required to apply row visibility filter based on the value of column 'B' (a multiplier column) with the following values:

  • 1 - for estimations - visible;
  • 0 - for roles - invisible;
  • (empty) - for section columns - visible.

use autofiltering feature for this.

It will make possible to show/hide roles row from standard Excel interface as well as it will make easier to insert new rows in the report (by hand).

@zhuj
Copy link
Owner Author

zhuj commented Dec 10, 2016

The first implementation (experimental option --filter-visibility) has been implemented.

Unfortunately there is bugs combination in both LibreOffice and XlsxWriter which make impossible to filter by both specific value «1» and blank value «(empty)» at the same time.

Partial fix has been added to the code: it makes the result report file acceptable for Excel and OneDrive, but unfortunately LibreOffice doesn't handle it.

This issue won't be closed until the bug is fixed on XlsxWriter library code.

@zhuj zhuj self-assigned this Dec 13, 2016
@zhuj
Copy link
Owner Author

zhuj commented Dec 13, 2016

Fixed by switching to OpenPyXL.
Now it works out of the box + no formula re-calculation is required.

@zhuj zhuj closed this as completed Dec 13, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant