Features

• Create new columns from existing columns! More documentation to come.
• Pin a column (or a pair of linked columns) so it’s always visible as you scroll through your spreadsheet
• Option to collapse headers to make more room for the table
• Export selected columns or rows as a downloaded file or as the contents of a new Rowboat window
• Reorder multiple columns by selecting them, then dragging on any of their drag handles

Fixes

• Fix hidden row markers being out of sync when scrolling in Safari
• Fix sort button not showing in single-value column
• Fix bug where dragging out of the table when selecting cells was causing the selection to flip
• Fix error when deleting multiple new columns
• Fix crash that could happen after repeated filtering in large files
• When geocoding or creating a new column, account for current filter or sort
• Fix header chart not highlighting when hovering on the cell in the right half of a pair of linked columns
• Fix selected cells not moving when their columns are moved
• Fix Replace All only replacing first instance in each cell
• Ensure dropdowns and tooltips are displayed on the top layer and within the bounds of the viewport

Miscellaneous

• Prevent columns from being deleted or edited while geocoding
• When dragging to select cells, nudge scroll at edges for continued dragging
• Make cell editing box more compact and positioned within the cell
• Improve border layering for table cells for clearer hover and selection styles
• Disable most options in context menu when hidden columns are selected
• Reset hover when mousing into empty space and reset selection when clicking into empty space

Features

• [Desktop] Support launching with multiple files at once

Fixes

• Fix duplicate event listeners causing unexpected behavior on popups
• Fix copying cells when columns are selected

Miscellaneous

• Change menu items to title case
• Re-order user menu
• Fade in/out header launch buttons on hover

Features

• You can now select multiple columns to perform an action on the set of columns, such as:
  • Inline Representations
  • Split (splits them each by the delimiter, then appends the new columns after the original columns)
  • Join (joins all columns together)
  • Duplicate
  • Trim
  • Change Case
  • Hide
  • Revert Changes
  • Delete
• Implement Cmd/Ctrl+A to select all cells (when table is selected)
• Implement using Shift + arrow keys to expand cell selection

Fixes

• When navigating with keyboard, scroll current cell into view
• Fix offset column selection after deleting column
• Ignore mouse dragging event if targeted at table scrollbar
• Apply selected styles to linked column headers
• Fix focus issues resulting from selecting an option from the context menu
• Fix purging filters when editing or deleting columns
• Clear selected cells or rows when data updates (e.g. filtering, header row toggling)
• Fix regular expression bugs in Find and Replace
• More efficient Replace and Replace All operations
• When copying cells, use correct column indices and filter out hidden columns
• Correctly handle merging or renaming entries to an empty string

Miscellaneous

• Show highlight styles on row numbers and column titles when they contain selected cells
• Improve gzip handling

We have an exciting batch of updates around interacting with the columns and rows in your data.

Features

• Select columns and right-click to perform column actions. Multi-column actions are limited for now, but more are on the way!
  • Double-click a column name to edit or select “Rename” from the right-click menu.
  • Restore hidden columns from the file summary.
• Select rows and right-click to copy or hide them.
• Select cell ranges and right-click to copy their contents.
  • Double-click a cell to edit.
  • Selecting a single cell also gives you the context options to edit the value or filter to it.
  • If a cell contains only a URL, holding Command (Control on Windows) while clicking opens the URL.

Fixes

• When adding or previewing new filters, scroll the filter section to show the most recent filter
• Prevent accidental duplicate operations on “Replace” or “Replace All”
• Fix Excel parsing sometimes failing to split columns correctly
• Fix alignment of Excel loading message
• Fix incorrect highlights in search view when filtered down to a set of rows
• Use dynamically sized filter input fields
• Sorted Values: fix chart not re-drawing when app theme is changed
• Sorted Values: fix chart not displaying negative data values
• Fix crash when setting a column to Time type when time format is not recognized
• When resizing a column, provide scroll nudges at the left bounds of the screen as well as the right
• [Desktop] Fix filtering causing crashes
• [Desktop] Fix crash when opening additional files from Finder

Miscellaneous

• Refreshed color palettes to support selection styles
• Use a custom alert dialog when Rowboat crashes

Features

• Make global and find filters editable
• Make linked columns resizable and draggable
• Select multiple table rows to hide in batches
• Find and replace in a column
• [Browser] Support opening files compressed with gzip
• [Desktop] Enable “Open in Rowboat” to open chart data in a new window
• [Desktop] Extend file associations to easily allow opening .xls, .xlsx, .txt, and .tab files

Fixes

• Remove filters before geocoding
• Fix error when filtering on a value with a newline
• Fix error when filtering from a bar chart in a numeric column
• Allow for multiple string filters (don’t replace existing ones)
• Fix bug where table tooltip would not show when re-entering from copy button
• Fix mismatches when highlighting results in search or find and replace
• Fix bug where a set of OR filters and a set of AND filters were considered the same
• Improve performance of homepage animation
• Keep “restore row” tick markers in place when scrolling
• Bar chart: searching should respect sort and vice versa
• Update drag-and-drop hover style
• Ensure word break to avoid overflow in recent file list
• Improve size and position of date format popup
• [Desktop] Use OS file dialog when exporting column snapshots, chart images, and chart data
• [Desktop] Add option to “Skip This Update” in update dialog
• [Desktop] Allow closing all windows without quitting the application
• [Desktop] Improve separation of items in menus

Miscellaneous

• Add link to docs in file summary
• More consistent error handling
• Update dependencies