[libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Am 09.08.2011 18:13, Giovanni Romero Pérez wrote: Hello, everybody! I used DataPilot in LibreOffice Calc, but I would like to format the column headers. More specifically, I want to change the text orientation or these headers. Thank you for your help. GIOVANNI ROMERO PÉREZ This is not possible, I'm afraid. The formatting is done by means of styles, except for the number format which is taken from the source data. Row fields and column fields share the same style which is named "DataPilot Category" in English GUI. Greetings, Andreas -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Joe,
Download this document:
http://www.mediafire.com/?qfhk56r2eyihccu
The 3rd sheet has a data pilot derived from the data on the first sheet.
Apply whatever format to the column headers ("Category 1" etc.).
Then call Data>DataPilot>Refresh from the menu or the pilot's context menu.
You may also select a header, look up the underlying cell style in the
stylist and modify that. In this case the formatting will survive a
refresh but the formatting is applied to the row headers as well.
--
For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Am 10.08.2011 01:57, jorge wrote: Hi I suggest you this: 1) Make the pilot data 2) If you format cell orientation (cell of pilot selected), you can chage the orientation (Vertical in grade that you want, except the first column). If you want to change the titles of headers, select the cell and use F2 to do it. 3) If you want to change all the columns headers orientations you can copy the pilot data to other space or sheet and then change the format cell orientation (Menu-Format-Cell) When you do this by means of hard attributes, they will be lost on refresh. When you do this by means of styles, it applies to the row headers as well. When you copy the pilot you don't have a refreshable pilot anymore. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Am 11.08.2011 01:28, jorge wrote: Hi I'm sorry but I made an example with Style and the first column header (Title) wasn't changed. Besides, I refreshed the pilot table and lost the headers format. What did I wrong ? The pilot uses one distinct set of automatically generated styles. For column headers in the English GUI the style is named "DataPilot_Category". When the pilot is rebuilt on refresh, all formatting falls back to that style. - Application of some other style will be reset to "DataPilot_Category". - Hard attributes will be reset to the bare "DataPilot_Category" settings. - Modifying "DataPilot_Category" itself will format both, row headers and column headers. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Hi I'm sorry but I made an example with Style and the first column header (Title) wasn't changed. Besides, I refreshed the pilot table and lost the headers format. What did I wrong ? Regards, Jorge Rodríguez El mié, 10-08-2011 a las 13:48 +0200, Andreas Säger escribió: > Am 10.08.2011 01:57, jorge wrote: > > Hi > > > > I suggest you this: > > > > 1) Make the pilot data > > 2) If you format cell orientation (cell of pilot selected), you can > > chage the orientation (Vertical in grade that you want, except the first > > column). If you want to change the titles of headers, select the cell > > and use F2 to do it. > > 3) If you want to change all the columns headers orientations you can > > copy the pilot data to other space or sheet and then change the format > > cell orientation (Menu-Format-Cell) > > > > When you do this by means of hard attributes, they will be lost on refresh. > When you do this by means of styles, it applies to the row headers as well. > When you copy the pilot you don't have a refreshable pilot anymore. > > -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: LibreOffice Calc: Format column titles in DataPilot
Hi Thank you, I understand now. I used it as you say and I could modify all the headers (The first Column included), but the data headers (Where the sum, average or other calcs are), change to its original formats when the pilot data is refreshed (The first column header and Data Title keep its format changed. Regards, Jorge Rodríguez _ El jue, 11-08-2011 a las 11:24 +0200, Andreas Säger escribió: > Am 11.08.2011 01:28, jorge wrote: > > Hi > > > > I'm sorry but I made an example with Style and the first column header > > (Title) wasn't changed. Besides, I refreshed the pilot table and lost > > the headers format. > > > > What did I wrong ? > > > > The pilot uses one distinct set of automatically generated styles. For > column headers in the English GUI the style is named "DataPilot_Category". > When the pilot is rebuilt on refresh, all formatting falls back to that > style. > - Application of some other style will be reset to "DataPilot_Category". > - Hard attributes will be reset to the bare "DataPilot_Category" settings. > - Modifying "DataPilot_Category" itself will format both, row headers > and column headers. > > -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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
