Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


Am 13.03.2012 18:05, Fernand Vanrie wrote:
Andreas ,

Thanks for your interest
With "grouping" i meaned having the content of the grouped column on top
or at the bottom off the items off the same group.
We where thinking on a macro who use a resulstet to fill the spreadsheet
cell by cell with some counters who are making a groupheader or footer
when the content of a column changed to a different vallue.
I look also a bit closer to the pivot tables

Greetz

Fernand


Pivot tables group like this:
CategoryA       A1
                A2
                A3
CategoryB       B1
                B2
                B3
                B4
CategoryC       C1
                C2
                
A conditional format can do the same for flat import ranges. Apply number format "";"";"";"" when this value is the same as the previous value.



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.