![]() |
#1
|
|||
|
|||
![]() When I add text 'inside' the task bar, it is left justified. Can it be center justified? Project Professional 2010. |
#2
|
|||
|
|||
![]()
No, not to the best of my knowledge.
|
#3
|
|||
|
|||
![]()
Hi,
as Julie said it's not possible in standard, but you can workaround using a custom field as I just posted here for you: http://community.allocatus.com/blogs...arstellen.aspx Best, Renke |
#4
|
|||
|
|||
![]()
Thank you Renke!
|
#5
|
|||
|
|||
![]()
This appears to be a great solution. My German is not good so I can't read what is on the link.
I muddled my way around and discovered how to add a custom field and am trying to understand what to do based on the pictures and not the German. I have copiedthe formula and am getting a syntax error, the semi-colon just before the first [Start]. If I change the semi colon to a comma, the syntax error moves to the next semi-colon. IIf(2,6*DateDiff("d";[Start];[Finish])+1-(len([Name]))>0;space(2,6*DateDiff("d";[Start];[Finish])+1-(len([Name]))) & [Name];[Name]) Any thoughts on what I am doing wrong? Thanks. |
#6
|
|||
|
|||
![]()
Try replacing the ; with a comma.
|
#7
|
|||
|
|||
![]()
Thanks Julie. The compiler now stopped at the ampersand (&). I tried replacing this with AND and it still didn't like it.
Any other ideas? |
#8
|
|||
|
|||
![]()
Hi,
I'm getting regular errors as well, but haven't had time yet to try to sort it out. I'll let you know when I have a chance to crack it. |
#9
|
|||
|
|||
![]()
I am getting closer with:
IIf(DateDiff("d",[Start],[Finish])+1-len([Name])>0,Space(3*DateDiff("d",[Start],[Finish])+1-len([Name])) & [Name],[Name]) |
#10
|
|||
|
|||
![]()
I am beginning to understand this code a bit better. The issue I see is the 3x multiplier is dependent on the timescale you're using. SPACE returns a number that is used to create a blank section prior to writing the NAME. The blank space is a number of spaces as returned by the SPACE function. But the length of the space is probably not the same length as a 'day' represents on the gantt chart again depending on the time scale being used. In my case, where my time scale is very compressed I had to actually divide the number of spaces returned to get the text to fit on the bar.
I would hope there is a way to account for the time scale. |
#11
|
|||
|
|||
![]()
Custom formulas cannot react to user settings such as zooming in or out of the timescale. The only method I can imagine is to set the indentation within the task bar through VBA code - and I am not the person to help out with that, sorry.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
citizenzen | Word | 3 | 02-01-2013 12:24 PM |
![]() |
jyfuller | Word | 1 | 06-09-2012 09:51 AM |
Macro for absolute text box re-position | hobbsbaboo | PowerPoint | 0 | 03-15-2012 01:44 AM |
![]() |
Jamal NUMAN | Word | 4 | 07-01-2011 06:27 PM |
Shortcut inside Word 2010 or 2007 to format text | Ross | Word | 0 | 03-03-2010 05:54 PM |