January

7

2015

The term Carriage Return was originally coined after the lever mechanism used by old typewriters to return to the left and advance the paper to the next line.  In modern times, the concept seems to be used interchangeable between Line feed (LF) -the ASCII code (10) that move the cursor or a printer down one line (LF button in dot-matrix printers), followed by paragraph break or hard return.in current word-processing packages. Regardless of the terminology variation, when editing text notes or schedules in Revit you often need to add carriage returns. This is easily done by clicking the ENTER key.

 

The ENTER key breaks a text note.
 
 
Carriage returns in Schedules are a different story. Pressing the ENTER key while editing a cell in schedule would not create a carriage return, but close the edit mode of a cell. The widely known workaround is using the shortcut CTRL+ ENTER.
 
The CTRL + ENTER key combination would create a carriage return.
 
 

While CTRL+ENTER does work, editing the cell  to add the desire break is really cumbersome.  The schedule view would never display stacked lines, only single lines. The up and down arrow keys won't jump the cursor to the paragraphs below, nor the PgDN or PgUP.  The only way to make edits across multiple paragraphs is by dragging the cursor to the right or left and clicking the forward or backspace as many times as needed to get to the appropriate character.

 

Dragging a selection of text to the cell border would move the cell string to a different paragraph line.

The drop down arrow selector on right side of the cell will reassign the text to either one of the paragraph and delete the rest. CTRL+ENTER would assign for each paragraph an independent choice.   Do not use or you will have to retype the entire text note.

Do not use the drop down arrow selector in a multi-paragraph note. It will keep a single paragraph and remove the rest.

Troubling as it is, while editing multiline cells is possible, you cannot add an empty line at the end of the paragraph. The CTRL + ENTER combination at the end of a paragraph in a cell will not create a carriage return, a major formatting drawback and a long standing feature request½ or is not?

We researched the issue and found a workaround reported by some users who were able to add an empty line by adding the ASCIII 'empty space character' code at the end of carriage return. (CTRL+ENTER followed by ALT+0160).  I was, for some reason, unsuccessful to make it work, at least on my installed RAC 2015 R2 version.

But one way I make this work (or faking it to work?) is by adding a parameter that creates an invisible narrow column with enough character values to force the return. Here is the workaround:  I created a new parameter of the integer type, added a number of characters equal to the number of lines plus one, and reduce the column width to a single character.

Create a blank space at the end of a cell, add a parameter that create a narrow invisible column with a number of characters equal the number of lines plus one, and change the column font color to RGB 254-254-254.
RGB Color 254,254,254 will never print.

 

To make the column invisible, change the font color. Changing the color to true white directs REVIT to display it in Black, therefore, change color to RGB 254,254,254 which is technically a grey color so light that it would ever print.

For lengthy schedules with various paragraph lines per cell, this method would be somewhat tedious. The task, though, would be far easier if we could make the edits in Excel. Using Ideate BIMLink, you can export the data to an Excel Spreadsheets and add the 'invisible' characters there.

Edit all your keynotes descriptions in Excel, making sure you add manually the 'carriage return' where needed. In Excel, the carriage return is added manually using the ALT+ENTER combination.

The idea is to create populate the 'invisible parameter' with a total number of characters that equal to the amount of line spaces in a cell plus one.

The process can be automatized using Excel formulas.  The formula parameters is explained below:

 

=LEN(C2)
Counts the total number of characters in a cell
=CHAR (10)
The Excel function of the 'line feed' (carriage return) symbol
=SUBSTITUTE(C2,CHAR(10),"")
Delete all the 'line feed' symbols in a cell (substitute them by 'nothing')
=LEN(C2)-LEN(SUBSTITUTE(C2,CHAR(10),""))
Count the total number of 'line feed' symbols in a cell

 

The final formula to create a value that equal the amount of line spaces plus one is as follows: =POWER(10,LEN(C2)-LEN(SUBSTITUTE(C2,CHAR(10),"")))*10 -If the number of line spaces in a cell is 2 = 100 - If the number of line spaces in a cell is 3= 1000 - If the number of line spaces in a cell is 4 = 10000½ etc. The data can then be reimported into Revit, forcing the 'narrow' column to wrap and giving you that magical carriage return space. Watch a video on Carriage Returns on YouTube.


About the Author

César Escalante - AIA, CCCA AEC Application Specialist
César is a licensed Architect with more than 12 years of experience leveraging architecture, design, and construction technologies in the AEC industry. He has an extensive expertise managing, implementing, and supporting all facets of BIM, IPD, and VCD workflows that includes the use of mobile and cloud technology during design and construction. César has played an instrumental role deploying successful strategies for multidiscipline coordination of large, technically complex, multimillion dollar projects. An innovative thinker, he is recognized as a leader at the forefront of BIM technologies, and he is a passionate educator. César is a LEED accredited professional and a Certified Construction Contract Administrator. He is currently a member of the buildingSMART alliance and the National Institute of Building Sciences. @VCDwhiz


 


X

Ideate Software is compliant with the General Data Protection Regulation (GDPR). We’ve updated our Privacy Policy and Terms of Use to reflect this. Please read these updated terms and take some time to understand them.

Note: We use cookies to improve your browsing experience and help us improve our website.

By continuing to use our website, you agree to the terms of use and to our use of cookies.

I ACCEPT