Below are known Excel issues with Ideate Sticky for Revit. Excel features or conditions that are not supported by Ideate Sticky as well as any other known limitations. For tips on managing some of the Excel-related limitations, refer to the topic Editing in Excel.
Ideate Sticky updates should be implemented for everyone within a company at the same time in order to maintain visual fidelity. For example, if one person updates Ideate Sticky to take advantage of the new lineweight settings feature, but others working within the same project do not have this latest update of Ideate Sticky, then the result will be that the cell border lineweight may vary depending upon whomever last updated the Sticky. In this situation Ideate Sticky will retain the lineweight settings within the Revit project, but will only apply those lineweight setting rules when the version of Ideate Sticky that supports those settings is being used to update the Sticky. Related topics: Adding to a Revit Deployment
While all common math and lookup formulas are supported, there are a few Excel formulas that are not supported by Ideate Sticky:
The IFNA Excel formula is not currently supported, but can often replaced with ISNA. Example:
The CEILING.MATH Excel formula is not supported, by can often be replaced with CEILING. Example:
Formulas that refer to a named region with a “.” (period) in the name of the region (“named.region”). To resolve, replace the period with other characters, e.g. “_” (underscore) and point the formulas to the new named region.
The specific set of formulas containing SUBTOTAL(10X, ...
The 100+ range tells Excel to omit hidden rows, the 1-11 range calculation include the hidden rows.
The SHEET formula must have a value
Support for images is available with versions 2015 and forward. Word Art (and images within version 2014) will be ignored on import. Images that are also hyperlinks (such as those generated by the Navis Clash Report) are not currently supported. To import a Clash Report image, first remove he hyperlink associated with the image.
Word Art, Shapes, and SmarArt are not supported. Use the Insert>Picture or Insert>Symbol option as possible workarounds.
In order for images to work as expected they should not be grouped, rotated, or flipped as these functions will be ignored by Ideate Sticky.
When an image is placed inside the Revit project, it is always placed on the active workset. This means that when a Sticky with images is created OR updated, the workset of the image will be the active workset. If a Sticky-related image is located on a workset that is wholly owned (checked out) then that Sticky cannot be updated, even thought the rest of the Sticky is editable. In these instances you will receive a Revit error about the owner of that workset. The solution will be to have that user relinquish the workset. Then, with another workset active, you should be able to update the Sticky with the images. Please see Errors and Warning Messages for Ideate Sticky for Revit concerning Worksharing.
Excel has (14) hard-wired line styles, two of which have no reasonable match with Revit: Double, Slanted Dash Dot. Refer to Mapping Excel Line Styles in Ideate Sticky for Revit for more information.
The Revit Schedule tool does not support patterns and as such will be ignored. Consider using color fills instead.
Conditional formatting is currently not supported. Color fills, text overrides, etc., that are a result of conditional formatting will be ignored. The underlying cell formatting, which can be seen when you place your cursor within the cell, will be utilized instead. Related topic: Work with Excel Pivot Tables in Ideate Sticky for Revit.
Font effects such as strikethrough, subscript, and superscript are not support by Revit's Schedule Header and therefore will be ignored.
Font overrides are changes made in Excel to the contents of the cell (wholly or partially) as opposed to the cell level font settings. Examples of this include partial red or bold text. This kind of formatting is not supported by the Revit Schedule Header and therefore will be ignored.
Not all special text characters are supported. Special characters vary with each font used. Refer to Using Special Characters for Revit with Ideate Sticky for detailed information.
Ideate Sticky strives for the greatest visual fidelity between the Excel Spreadsheet and the Revit Schedule as placed on a sheet. However as a condition of the way that Revit renders or displays the text, the line spacing between the top and bottom of the cell in Revit may vary slightly as a function of the font type, font size, and the length of the text within each cell.
The Revit Application Programming Interface (API) does not support splitting a schedule header element, therefore, to break a Sticky into more than one page you will need to separate the information within Excel. Refer to Manage the Size of Sticky with Ideate Sticky for Revit for more information.
The use of Excel named regions is limited to a single array and is not supported by multiple ranges defined within a single name.
Header and Footer text and formatting within the Excel file will be ignored.
Ideate Sticky is incompatible with the original shipping version of Revit 2014 but will work when Revit Update Release 2 (or later) is applied.
Ideate Sticky schedules are native Revit elements, but we use the schedule title to display the Excel information. For any Sticky schedules that are not displaying properly, check the schedule properties. In the appearance tab, the "Show Title" should be turned on. In many cases, an applied schedule view template has unchecked these properties.
Note: The “Blank row before data” checkbox adds or removes one empty row between the column title and data rows.
In certain rare cases Ideate Sticky may not able to read the contents of an Excel sheet. The resulting error is similar to this one:
This error tends to be caused by unexpected conditions inside the Excel file, i.e.:
The best way to move forward in this situation is to use the native Excel tool to inspect and clean the file (File -> Info -> Check for Issues).
If you are still having trouble afterwards, feel free to contact Ideate Support for more help.
Thank you for taking time to inform us about a bug or feature request.