Tab character (Calc): verschil tussen versies

Uit De Vliegende Brigade
Naar navigatie springen Naar zoeken springen
k (Jeroen Strompf heeft pagina Tab (Calc) hernoemd naar Tab character (Calc))
Regel 1: Regel 1:
I've come across a strange problem (July 2022): I can't just insert a ''tab'' into a cell and preserve it when copying the content of that cell to a text file.
+
I've come across a strange problem (July 2022): I can't copy multiple rows that contains at least one tab character, and have that tab character preserved. It doesn't matter if I am copying within Calc, or to e.g., a text editor.
 +
 
 +
* When copying the content of a singular cell (just by selecting the cell, not going into the cell and selecting its content), tab characters do get preserved
 +
* Tab characters are not displayed in cells - That's bearable.
 +
 
 +
I can't find much about this issue, and actually only one link (see below).
 +
 
 +
Solution for now: Use 4 spaces in stead of tab
 +
 
 +
* At the destination, I could convert those spaces back to tab, if needed
 +
* Four spaces works as a separator when migrating data into different columns in Calc.
 +
 
 +
== Sources ==
 +
 
 +
* https://ask.libreoffice.org/t/copy-the-result-of-char-9-of-calc-formula-and-paste-in-libreoffice-calc-basic-ide/65048

Versie van 2 aug 2022 07:44

I've come across a strange problem (July 2022): I can't copy multiple rows that contains at least one tab character, and have that tab character preserved. It doesn't matter if I am copying within Calc, or to e.g., a text editor.

  • When copying the content of a singular cell (just by selecting the cell, not going into the cell and selecting its content), tab characters do get preserved
  • Tab characters are not displayed in cells - That's bearable.

I can't find much about this issue, and actually only one link (see below).

Solution for now: Use 4 spaces in stead of tab

  • At the destination, I could convert those spaces back to tab, if needed
  • Four spaces works as a separator when migrating data into different columns in Calc.

Sources