![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
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
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
*It seems to me that you can. I have attached an .ods with various orientations, and sent it directly to Giovanni and Andreas.*
*One thing I noticed right away - there is a serious bug when changing orientations, in that it is difficult to keep the text within the cell. As I was rotating the text it would often bounce into the adjoining cell. It seems that the text alignment feature does not extend to rotated text, and chooses any random alignment.*
*Joe Conner, Poulsbo, WA USA*
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)
Regards,
Jorge Rodríguez
Hi Joe,
JOE Conner wrote (09-08-11 23:04)
*One thing I noticed right away - there is a serious bug when changing
orientations, in that it is difficult to keep the text within the cell.
As I was rotating the text it would often bounce into the adjoining
cell. It seems that the text alignment feature does not extend to
rotated text, and chooses any random alignment.*
In the section Rotation, you can choose the reference boarder too.
Joe,
Download this document:
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.
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.
True, the selection is possible. However selecting a different
edge does not have the desired effect. In fact, the effects are
unpredictable and illogical.
A true bug.
Joe Conner, Poulsbo, WA USA
JOE Conner wrote (10-08-11 20:15)
JOE Conner wrote (09-08-11 23:04)
*One thing I noticed right away - there is a serious bug when changing
orientations, in that it is difficult to keep the text within the cell.
As I was rotating the text it would often bounce into the adjoining
cell. It seems that the text alignment feature does not extend to
rotated text, and chooses any random alignment.*In the section Rotation, you can choose the reference boarder too.
True, the selection is possible. However selecting a different
edge does not have the desired effect. In fact, the effects are
unpredictable and illogical.
Might well be - I did not use it often. Though from the last times I remember, I could cope with it.
A true bug.
Might well be too - could you please be so kind to find out what works and what not, a sort of pattern, and file a bug with that 
Thanks,
Hi
Here is the guide for posting bug-reports.
http://wiki.documentfoundation.org/BugReport
Note that it is a guide only, not a set of rules. If you can't follow all of it
the just post as the devs can always ask for extra info if they really need it.
Regards from
Tom
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
Bug report #39990 submitted.
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.
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