Bug: copy-pasting into table always pastes an additional, blank, cell

Bugs & Issues
1

As described in the title, copy pasting from Excel into Fibery somehow for me always adds an additional blank cell. This blank cell overwrites anything that is in that cell.

I.e. if I copy:

A
B

into

F
G
H

It not only correctly replaces F and G but deletes H by the inserted blank cell.

Is this only happening for me?

2

It’s not only happening for you :slight_smile:
Unfortunately, if you select a certain number of cells in Excel and copy paste them, what actually gets copied includes an extra carriage return at the end.
I’m not sure why it happens, but you can see if it you paste into any other program (e.g. Notepad).

I don’t know if it’s possible for Fibery to ignore/strip any carriage return at the end of pasted data. I’ll leave it to a dev to jump in here with any ideas :crossed_fingers:

3

I never considered this a bug, I’ve encountered similar behavior in Airtable, Coda, and other similar tools that mimic tabular data entry.

It can be annoying. If it’s possible to strip the extra carriage return, that would be fantastic!

4

True, makes sense that copying a cell doesn’t just copy its cell contents.

Thanks for the explanation! Maybe one day there will be solution.

5

Extra vote for Fibery to strip Excels naughty spare CRLF. It’s an excel ‘problem’ but would be great if Fibery stripped the trailing new line.

I had an ahk doing it for me on my main machine and then made so many mistakes doing excel->fibery work on a different machine today…

6

For others annoyed by this the ahk I use on my main machine:

; AutoHotkey v2 — paste clipboard minus trailing whitespace
; Bound to both Ctrl+Shift+V and the forward thumb button

PasteTrimmed() {
    A_Clipboard := RTrim(A_Clipboard, " `t`r`n")
    Send("^v")
}

^+v::PasteTrimmed()
XButton2::PasteTrimmed()