You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I don't think this is AFE-specific but perhaps there's something you can do about it anyway.
I use an Excel table and the REDUCE() function to build an array that I paste into AFE. The result is a mess, because the value that is pasted is pasted as a quoted string instead of as I see the value in the cell. I've reduced the problem to the image below.
Cell A1 is a single line of text. Copying and pasting that into AFE works as expected: the content is pasted as displayed.
Cell A3 is multiple lines of text. Copying and pasting that into AFE doesn't work as expected: the content is pasted with double-quote characters around it.
These hold true whether the cells are literals or formula results.
The multiline problem gets really messy if the lines themselves contain double-quote characters, which get replaced with two double-quote characters.
The text was updated successfully, but these errors were encountered:
I don't think this is AFE-specific but perhaps there's something you can do about it anyway.
I use an Excel table and the REDUCE() function to build an array that I paste into AFE. The result is a mess, because the value that is pasted is pasted as a quoted string instead of as I see the value in the cell. I've reduced the problem to the image below.
Cell A1 is a single line of text. Copying and pasting that into AFE works as expected: the content is pasted as displayed.
Cell A3 is multiple lines of text. Copying and pasting that into AFE doesn't work as expected: the content is pasted with double-quote characters around it.
These hold true whether the cells are literals or formula results.
The multiline problem gets really messy if the lines themselves contain double-quote characters, which get replaced with two double-quote characters.
The text was updated successfully, but these errors were encountered: