## 1.2.6 Bug Fixes: - Fixed a bug where the right-click row and column menus could be squashed to a fraction of their height — down to a single row — when opened low on the screen, especially on shorter viewports or with browser zoom. The menu's height was being derived from where it opened; it is now capped independently of position, and a menu that would extend past the bottom of the viewport is shifted upward instead of shrunk, scrolling internally only when it is genuinely taller than the viewport. ## 1.2.5 New Features: - **Group Rows (Beta)** — Right-click any row and click "Group Row" to create a collapsible row group. Click the minus (-) button to collapse the group and hide those rows, or the plus (+) button to expand and show them again. Right-click the group button for options to remove individual groups, show or hide all groups, or remove all groups. You can also right-click grouped rows and click "Ungroup Row" to remove them from their group. Groups are saved per sheet and restored automatically when you return. Works on both sheets and reports. Beta testers only. - **Group Columns (Beta)** — Right-click any column and click "Group Column" to create a collapsible column group. Works the same as Group Rows but on the horizontal axis — collapse to hide columns, expand to show them again. Handles frozen and unfrozen columns separately, so groups don't span the freeze boundary. Beta testers only. Updates: - **Freeze Rows is now available to all users** — The Freeze Rows feature, previously in beta, is now available to everyone. Right-click any row to freeze it at the top of your sheet. - **Include Hidden Rows option in Export** — Both Export to PDF and Export to Excel now have an "Include hidden rows" checkbox. It defaults to on, so exports include all rows. Uncheck it to exclude rows you've hidden with the Group Rows feature. - Bulk Create Cross-Sheet References now has a "Remove Spaces" option, so variable values like "My Sheet" become "MySheet" in the generated names. - Bulk Column Renamer's Find and Replace now includes an "Ignore Case" option for case-insensitive matching and replacement. - Auto Sort now has a "Retain cell selection" option. When enabled, SSFeatures will keep your selected cell or row in view after the sort re-orders the grid. This prevents losing your place when editing data with auto-sort on. - Bulk Create Columns now lets you define dropdown options when creating Dropdown List or Dropdown List (Multi) columns. Enter one option per line and the options will be applied to all created columns. - Conditional format rules now display with rich formatting in the copy/delete selector, including styled text, link highlighting, and a visual format sample preview. - The column selection step in Find and Replace now only shows columns that match the find query, keeping the list focused on columns that will actually be affected. - Duplicate cross-sheet reference names are now shown as a warning instead of blocking the operation. References that already exist are automatically skipped. - Import Into Sheet now validates that the import will not exceed Smartsheet's 20,000 row limit before starting, preventing failed partial imports. - Import Into Sheet now preserves row grouping (parent-child relationships) from Excel and ODS files. If your source file has grouped/indented rows, they will be automatically indented in Smartsheet after import. - Unfreeze Rows now unfreezes all frozen rows at once, rather than only unfreezing from the clicked row downward. - "Select All" buttons now switch to "Deselect All" when all items are selected, making the toggle behavior clear. - Increased the width of the Bulk Column Renamer popup for easier reading.

New Features: - Freeze Rows - You can now freeze rows at the top of your Smartsheet grid so they stay visible while you scroll. Right-click on a row and click "Freeze Row(s)" to pin it. Your frozen rows are saved per sheet and automatically restored when you reopen it.

Updates: - Added a tooltip to the "Total Cells Referenced" stat, to explain that this metric is calculated by Smartsheet and may have a delay. The tooltip explains why the metric might be too high. - Added a tooltip to the "Sheet Stats" popup which explains that all of the metrics are calculated by Smartsheet. Bug Fixes: - Fixed a bug where the first option in the SSFeatures menu displayed when it should not have, for both reports and sheets.

Updates: - Updated the Automation Sheet Improver Tooltip to hover above the "improvements" button to not block the button.

New Features: - View Column Info - This feature lets you see all of the information about your columns, such as the name, type, formulas, descriptions, dropdown options, etc. - You can export this information to Excel as well. - Automation Workflow Style Improvements - This feature updates the CSS style for several HTML elements in the automation workflow editor. This makes the editor easier to use. For example, previously it was difficult to read the text content in an email alert, because the HTML element could not be resized. SSFeatures now let's you resize it. Also, several sheet names, column names, and other text fields were truncated which made it hard to read the content. This now fixes that. Updates: - The Cross Sheet Reference Viewer now provides a link that opens up the source sheet for each reference. The URL of this link is exported to Excel as well. - Added more English words to the dictionaries, so that they do not show up as misspelled. - The en_US dictionary is now built directly into SSFeatures, so that it does not need to be fetched from the CDN. If a company has a VPN that blocks the SSFeatures CDN, the user will still be able to use the en_US dictionary. - Updated the spell checker logic so that it doesn't include punctuation marks, such as ? and ! as part of the word. - Fixed a bug in the PDF generator where workspace logos were not displaying properly. - Added a reset button to the Bulk CSR creator, so that people can reset the input to the default "{SHEET NAME} - {COLUMN NAME}" format. - Added an error message popup to the PDF generator. If an error occurs while generating the PDF, the user will see the error message and can send it to our support email. - Added advanced options to the Bulk CSR creator, so that users can specify a capitalization style, and a delimiter. - Added a way for users to select exactly which columns they want to rename, when using the "Prefix / Suffix" or "Find and Replace" modes, to rename columns. - Added CTRL + Alt + G as an alternative key combination for opening the "Go To Column" menu. Permissions: - Added the host_permissions for "\*.smartsheet.com" so that we can access URLs on the Smartsheet CDN directories. This allows us to fetch CDN assets, such as logos that have been added to workspaces. We need these images for exporting PDFs. Bug Fixes: - Fixed a bug in the Automation Workflow paster, where conditions with multiple "or" clauses, were treated as "and" clauses. In other words, SSFeatures was not considering the proper logical operator for the conditions. - Fixed a bug in the Automation Workflow paster, where SSFeatures was unable to paste automations if they used sub-conditions underneath an action. - Fixed a bug where the user could use the bulk column creator, and bulk column renamer, to accidentally rename columns to be longer than 50 characters. - Fixed a bug in the PDF generator where certain characters would break the generator which would cause the spinner to spin forever. These characters were things like \n and 0x0009.

Bug Fixes: - Fixed a bug in the PDF and Excel exporter where cells with a value of '0' or '0%' were not being displayed in the output cell. - Fixed a bug while copy and pasting automation workflows, which caused the triggers for "Any Value" and "Blank" to be incorrect. - Fixed a copy and paste automation bug where "Clear Cell" actions were not populated correctly.

Updates: - Updated how the data importer handles dates from Excel. Previously, the code tried to convert it into a JS Date object and then pass that value into Smartsheet. This didn't work well with different timezones. Now the date is passed directly into Smartsheet, and it's up to Smartsheet to handle the date properly. - Added a warning in the data importer when the user tries to import dates, to help them understand how it works and to increase their chance of success. Bug Fixes: - Fix a bug where Smartsheet's menu remained open when opening the SSFeatures sort popup.

Updates: - Updated the data importer to provide better error messages to the user, when they have an invalid filter. Bug Fixes: - Updated a few places where the console would emit undefined errors on certain key presses. - Updated the data importer to support importing data directly into predecessor DATE_TIME columns.

Updates: - Updated the sort and automatic sorting feature to allow users to properly sort selected rows. Previously, if the user selected rows, then tried to sort, it would sort all of the rows, rather than the ones the explicitly selected. This is now fixed. - Sheet stats now shows the proper value for "Cross Sheet References". Previously, it only showed the value for the number of cross sheet references that were being used. Now it shows all of them, even the unused ones, which properly replicates Smartsheet's limits. Bug Fixes: - Fixed a bug with the data importer, where filters were treating values as text, even when it made sense to treat the values as numbers. For example, the less than filter should always compare using numerical comparisons, rather than text comparisons. This was letting unexpected values through for users. - Optimized the spell checker to drastically improve performance when reading cells with large amounts of text.

Bug Fixes: - Fixed a bug with the data importer, which did not respect Smartsheet's 4000 character cell limit. This caused Smartsheet to not be able to save the sheet with these cells in.

Updates: - Added support for hyperlinks in the Excel importer. This only works when importing hyperlinks into a TEXT/NUMBER column. Bug Fixes: - Fixed a bug with the Excel importer, which prevented some sheets from loading. This occurred when the Excel file was missing a header row with column names.

New Features: - "Bulk Column Deleter" - Allows you to delete more than 5 columns at a time. - "Bulk Column Creator" - Allows you to create many columns all at once. Bug Fixes: - Fixed a bug with the spell checker that prevented it from correcting the misspelled word.

New Features: - "Copy and Paste Columns" - Allows you to copy and paste columns between sheets, or within the same sheet. - "Column Templates" - Allows you to create a template with columns, and apply the template to paste the columns into sheets. Updates: - Updates SSFeatures to work with the Australian Smartsheet instance (https://app.smartsheet.au/). - Adds an "Unhide all button" into the "Hide / Unhide Columns" menu. - Adds a new menu to the SSFeatures debug menu which allows people to reset SSFeatures' settings. This is useful in case something breaks and they need to reset SSFeatures. - Adds a new menu to the SSFeatures debug which allows people to import their SSFeatures settings. - Adds progress spinners while generating PDFs and excel files. - Adds progress spinners when pasting automation workflows. Bug Fixes: - Predecessor "Date Time" columns used to appear as "Date". Now they properly reflect being "Date Time" columns.

Updates: - Update SSFeatures to work with the Australian Smartsheet instance (https://app.smartsheet.au/). - The spellchecker now only runs on text columns. This will help improve the performance of the spellchecker by not needing to run on the other column types. - Optimized the spell checker by slowing down how fast SSFeatures tries to create the spell checker underlines. - Reduced the resource consumption for automatic sorting. Bug Fixes: - Fix a bug in in "Import data into this Sheet" which failed when the file had empty rows.

New Features: - "Report Column Descriptions" - Allows you to see column descriptions in your reports from the source sheet columns. - If your sheet contains more than 5 source sheets, the descriptions will only be pulled from up to 5. - "Report View Source Sheets" - Allows you to view information in your reports, about the source sheets used in your report. - This includes data such as: - The workspace and folder where each sheet lives - Buttons to open the sheet, folder, workspace, or report (in the same or a new tab) - Your permission level on each sheet - Who created it - When it was created - The sheet’s ID - The direct link (URL) to the sheet Updates: - Removed some dictionaries because they loaded too slowly. Bug Fixes: - Fixed a bug where the "Hide / Unhide Columns" quick menu "eye" icon briefly showed up in the top left corner while the page was loading. - Fixed a memory leak in the spell checker, caused by the highlight underlines not being cleaned up correctly.

Bug Fixes: - Fix the report and sheet PDF generator so that it works properly with Predecessors. Previously, the "start date" and "end date" did not appear correctly, and had the correct date but an incorrect time. This column now just shows the date. Also, the Predecessor column showed a JSON string, when it should have shown the human-readable string. These are both fixed.

Updates: - Enabled the PDF generator in sheets. - Updates the stats popup to show the number remaining, and the capacity percentage for each stat that has a limit. - Adds a filter in "Find Column IDs" popup, that allows the user to search for specific columns by using their ID. - Retain usage metrics in the local browser storage, so that the user can track which features they use the most. - Disabling the spellchecker will now immediately remove all of the spellchecker highlights. Previously, you had to refresh the page. - The report PDF generator will remember your most recently used settings. When you generate a report PDF for the first time, the most recently used settings will be used automatically. - Hides the alert settings options when viewing stats in a Report, because it doesn't make sense to show these settings in reports. Alerts aren't used in reports. - Makes the stats popup smaller in a Report. Bug Fixes: - Fix a bug where certain types of popups were not showing user metrics. Bug Fixes: - Fixed a bug in "Set Capitalization" for words like "McDonalds" which was converting it into "Mcdonalds" when using "First Letter Upper Case". - In the PDF generator, added more vertical spacing between the text for a grouped row. The texts were sometimes overlapping in the generated PDF. - In the PDF generator, fix a bug where cells were not appearing with certain types of complex cell or column formulas.

New Features: - Import Into Existing Sheet - SSFeatures now lets you import data directly into your sheet. - This supports Excel, CSV, TXT, and ODS files. - You can also filter your data, merge data into your sheet using a primary key, and replace the data in your sheet. - This gracefully handles all of the different column types in Smartsheet. For example, if you import emails into a contact column, SSFeatures will create all of the contacts for you. - Sheet Limit Alerts - SSFeatures will now send you alerts when your sheets start approaching a limit. You can configure these settings in the "Sheet Stats" menu. - The spellchecker now supports 80 languages and dialects. - You can disable the spellchecker on specific columns. Updates: - Made many improvements to the spellchecker dictionaries to be more accurate. - Made many performance improvements to the spellchecker to make it less laggy. - Removed columns with column formulas from the "Set Capitalization" popup. - Updated the capitalizer to not modify cells that have cell formulas. - Added the standard column filters to the "Go to Column" and "Find Column IDs" popups. - Renamed "Settings" to "Views" in the "Hide / Unhide Columns" popup. Bug Fixes: - Fix a bug where the SSFeatures menu could be clicked, even when the Form editor was visible. - Fixed a bug while copy and pasting automations, which occurred when using "When a Date is Reached". - Fixed a bug where clicking on a tooltip in a popup would close the popup.

New Features: - Capitalization Manager - Allows you set the capitalization format for your columns. You can find this in the SSFeatures menu under the "Set Capitalization" menu. - Remove Columns from Conditional Format Rules - Allows you select a column, and then remove that column from all of your conditional format rules. - Especially useful if you need to delete a column that is currently being used by the conditional formats. - "Hide / Unhide Columns" Settings Quick Menu - Added a button on the right hand side pane that lets you quickly open and load your "Hide / Unhide Columns" settings. Updates: - Updated the "hide / unhide columns" popup to move the "fx" column formula icon to its own column. - Added tutorial popups to help users learn how to use SSFeatures.

New Features: - Automation Workflow Copy and Paste - Allows you to copy and paste automation workflows within the same sheet or between different sheets. Updates: - Added the total number of referenced cells into sheet stats, and displays the 25M limit. - Updated "go to column" keyboard shortcut hint to be more apparent.

Updates: - Added a tooltip for new users to show them the SSFeatures toolbar button. - Improved the "hide / unhide window" - Tooltips to explain filters and settings - Save button to help users who get stuck not realizing how to persist the data. - Moved the save, load, and delete buttons to the top, next to the filters. - Added tooltips to the sort popup. Bug Fixes: - Fix a bug that displayed the account popup when it was not supposed to. Updates - Add guardrails to prevent the account popup bug from happening again. - Removes the contact us button from the Safari version.

New Features: - Column ID Finder - Popup that helps you quickly find and copy the column IDs. This is especially useful for API and SmartSheet Bridge users, since SmartSheet does not natively provide a way to access the IDs. - Sheet Stats - Popup that displays statistics about your sheet or report. Currently supports the number of rows, columns, cells, and cross sheet erferences. Updates: - Added the column type to the "Hide / Unhide Columns" popup. - Added the an icon to indicate if the column contains a column formula to the "Hide / Unhide Columns" popup. - Added a "Hide / Unhide Columns" button into the toolbar for easier access.

Updates: - Adds a highlight animation to the SSFeatures toolbar button for the first time that new users open the extension. - Add new metrics for the conditional format copy paster, deleter, and bulk cloner. Bug Fixes: - Fix a bug while loading column visibility settings which sometimes caused 1 extra column to be visible, even when it wasn't included in the settings. - Fix a bug while loading column visibility settings which sometimes the settings to not load correctly, if a column was previously deleted from the sheet. - Fixes a bug in the PDF generator which did not show checkboxes if the cell contained unsaved modifications.

New Features: - Conditional Format Copy and Paste - Allows you to copy and paste conditional formats between sheets or within the same sheet. - Conditional Format Mass Deleter - Allows you to delete multiple conditional formats at the same time. - Conditional Format Clone Rule for Columns - Allows you to select a rule, then select columns, and then SSFeatures will clone the rule for each column. - Added configurations that allow to quickly hide and unhide groups of columns in the "hide / unhide columns" menu. - Added a "Go to Column" button that makes it easy to quickly find a column in a sheet or report. You can open this with Alt + G or Option + G. - Added a "Go to Column" button in the column visibility popup. - Added an option in the PDF generator that allows you to filter the rows down to just the grouped rows or just the non-grouped rows. Updates: - Updated all of the filter buttons to be fixed to the top of the popup, rather than scroll. This makes it easier to use the filters. Bug Fixes: - Fix a bug in the Conditional Format copy/paster and cloner which incorrectly set the selectable dropdown options.

New Features: - [Beta] Conditional Format Copy and Paste - Allows you to copy and paste conditional formats between sheets or within the same sheet. - [Beta] Conditional Format Mass Deleter - Allows you to delete multiple conditional formats at the same time. - [Beta] Conditional Format Clone Rule for Columns - Allows you to select a rule, then select columns, and then SSFeatures will clone the rule for each column. Updates: - Added support for SmartSheet EU (https://app.smartsheet.eu) - Added support for SmartSheet WorkApps (https://workapps.smartsheet.com, https://workapps.smartsheet.eu) Bug Fixes: - Increased the PDF generator buffer deadline to reduce the chance of errors. - Fixed a bug in the PDF generator that removed the background color on unchecked checkbox cells.