When using the blueprint functionality in the Distribution lists, it looks like the auto-hide rules aren't being applied to each worksheet created. Instead, it looks like the autohide rules are set by the first worksheet and applied to the rest. This makes it difficult to view detail reports that use our roll-ups, as we wanted to use the blueprint functionality to export out reports for department divisions and each of the breakouts underneath them. However, the exported files contain rows that should be hidden for each breakout. Here's an example:
This is the distribution list using the blueprint functionality to pull a detailed income statement for our company 10 and each of the divisions under it.
When we distribute it, the first worksheet looks good:
But the other worksheets have the same rows hidden as the first:
Is there a way to apply autohide rules to each worksheet created when distributing using the blueprint functionality? We are using the current Velixo Classic release, 7.1.557.10639 (64 bit, Insider Channel)
0 Votes
3 Comments
Sorted by
Gabriel Michaudposted
27 days ago
Admin
Glad you were able to figure it out. For reference, the configured auto-hide ranges can be found in the name manager box of Excel -- they're saved under each sheet, and named "VelixoAutoHideZeroRows" or "VelixoAutoHideZeroColumns".
0 Votes
D
Derek Daaneposted
27 days ago
We are on Velixo Classic release, 7.1.557.10639 (64 bit, Insider Channel)
I think I was able to figure out the issue. Our report was using a ton of different cell ranges for the autohide zero rows rules. We were adding in a separate range for the data and headers in each revenue/expense category, so it was over 60 different ranges. I updated our report to use a helper column to help identify if we wanted to always show or dynamically hide specific rows and updated the auto hide row rules to use that instead. By switching from 60+ different ranges to just 1, the autohide started being applied correctly to each exported report using the blueprint functionality. We're just started using Velixo and creating our own reports, so we're still learning best practices.
0 Votes
When using the blueprint functionality in the Distribution lists, it looks like the auto-hide rules aren't being applied to each worksheet created. Instead, it looks like the autohide rules are set by the first worksheet and applied to the rest. This makes it difficult to view detail reports that use our roll-ups, as we wanted to use the blueprint functionality to export out reports for department divisions and each of the breakouts underneath them. However, the exported files contain rows that should be hidden for each breakout. Here's an example:
This is the distribution list using the blueprint functionality to pull a detailed income statement for our company 10 and each of the divisions under it.
When we distribute it, the first worksheet looks good:
But the other worksheets have the same rows hidden as the first:
Is there a way to apply autohide rules to each worksheet created when distributing using the blueprint functionality? We are using the current Velixo Classic release, 7.1.557.10639 (64 bit, Insider Channel)
0 Votes
3 Comments
Gabriel Michaud posted 27 days ago Admin
Glad you were able to figure it out. For reference, the configured auto-hide ranges can be found in the name manager box of Excel -- they're saved under each sheet, and named "VelixoAutoHideZeroRows" or "VelixoAutoHideZeroColumns".
0 Votes
Derek Daane posted 27 days ago
We are on Velixo Classic release, 7.1.557.10639 (64 bit, Insider Channel)
I think I was able to figure out the issue. Our report was using a ton of different cell ranges for the autohide zero rows rules. We were adding in a separate range for the data and headers in each revenue/expense category, so it was over 60 different ranges. I updated our report to use a helper column to help identify if we wanted to always show or dynamically hide specific rows and updated the auto hide row rules to use that instead. By switching from 60+ different ranges to just 1, the autohide started being applied correctly to each exported report using the blueprint functionality. We're just started using Velixo and creating our own reports, so we're still learning best practices.
0 Votes
Gabriel Michaud posted about 1 month ago Admin
Hi Derek,
I'm trying to replicate the issue, but was unsucessful: https://www.loom.com/share/ce24ee03884f4bd68ab068733c740e52
The file I used is attached. Can you try on your side to see if my file works?
Can you put =VELIXOVERSION() in a cell and tell me what you see?
Attachments (1)
BlueprintAut....xlsx
22 KB
0 Votes
Login or Sign up to post a comment