Hide empty Rows in Excel (pivot tables)

Dear all,

in pivot tables, when a user selects the option “Hide Empty Rows” and downloads the pivot table as an Excel spreedsheet, the xls file shows all the rows, it does not matter if they are empty or not. Is it possible to change that behaviour?

thanks

Jose

Yes, It’s good to make all be consistent. Not only Excel spreedsheet, but also others.

···

2013/12/23 Jose Garcia Muñoz josemp10@gmail.com

Dear all,

in pivot tables, when a user selects the option “Hide Empty Rows” and downloads the pivot table as an Excel spreedsheet, the xls file shows all the rows, it does not matter if they are empty or not. Is it possible to change that behaviour?

thanks

Jose


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134

Hi Jose,

thanks for the suggestion, we can fix that.

regards,

Lars

···

On Tue, Dec 24, 2013 at 5:19 AM, Thái Chương thaichuong159@gmail.com wrote:

Yes, It’s good to make all be consistent. Not only Excel spreedsheet, but also others.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/23 Jose Garcia Muñoz josemp10@gmail.com

Dear all,

in pivot tables, when a user selects the option “Hide Empty Rows” and downloads the pivot table as an Excel spreedsheet, the xls file shows all the rows, it does not matter if they are empty or not. Is it possible to change that behaviour?

thanks

Jose


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134

Hi again Jose,

we have fixed this now. The “hide empty rows” option is now implemented on the server side in the development version. Will be part of the 2.14 release which is just around the corner.

Lars

···

On Tue, Dec 24, 2013 at 2:29 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Jose,

thanks for the suggestion, we can fix that.

regards,

Lars

On Tue, Dec 24, 2013 at 5:19 AM, Thái Chương thaichuong159@gmail.com wrote:

Yes, It’s good to make all be consistent. Not only Excel spreedsheet, but also others.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/23 Jose Garcia Muñoz josemp10@gmail.com

Dear all,

in pivot tables, when a user selects the option “Hide Empty Rows” and downloads the pivot table as an Excel spreedsheet, the xls file shows all the rows, it does not matter if they are empty or not. Is it possible to change that behaviour?

thanks

Jose


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134

Hi Lars,

many thanks! That feature was really important for most of PSI facilities.

···

On Thu, Jan 2, 2014 at 10:09 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi again Jose,

we have fixed this now. The “hide empty rows” option is now implemented on the server side in the development version. Will be part of the 2.14 release which is just around the corner.

Lars

On Tue, Dec 24, 2013 at 2:29 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Jose,

thanks for the suggestion, we can fix that.

regards,

Lars

On Tue, Dec 24, 2013 at 5:19 AM, Thái Chương thaichuong159@gmail.com wrote:

Yes, It’s good to make all be consistent. Not only Excel spreedsheet, but also others.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/23 Jose Garcia Muñoz josemp10@gmail.com

Dear all,

in pivot tables, when a user selects the option “Hide Empty Rows” and downloads the pivot table as an Excel spreedsheet, the xls file shows all the rows, it does not matter if they are empty or not. Is it possible to change that behaviour?

thanks

Jose


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134

Sounds good.

···

On Fri, Jan 3, 2014 at 12:03 AM, Jose Garcia Muñoz josemp10@gmail.com wrote:

Hi Lars,

many thanks! That feature was really important for most of PSI facilities.

On Thu, Jan 2, 2014 at 10:09 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi again Jose,

we have fixed this now. The “hide empty rows” option is now implemented on the server side in the development version. Will be part of the 2.14 release which is just around the corner.

Lars

On Tue, Dec 24, 2013 at 2:29 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Jose,

thanks for the suggestion, we can fix that.

regards,

Lars

On Tue, Dec 24, 2013 at 5:19 AM, Thái Chương thaichuong159@gmail.com wrote:

Yes, It’s good to make all be consistent. Not only Excel spreedsheet, but also others.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2013/12/23 Jose Garcia Muñoz josemp10@gmail.com

Dear all,

in pivot tables, when a user selects the option “Hide Empty Rows” and downloads the pivot table as an Excel spreedsheet, the xls file shows all the rows, it does not matter if they are empty or not. Is it possible to change that behaviour?

thanks

Jose


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thai Chuong
HCMUT - Computer science and engineering Faculty

Website: http://thuytruc.net

YM/Skype : thaichuong159
Email: thaichuong159@gmail.com
Phone: (+84) 918776134