Tab character (Calc): verschil tussen versies
Naar navigatie springen
Naar zoeken springen
(Nieuwe pagina aangemaakt met '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.') |
|||
(5 tussenliggende versies door dezelfde gebruiker niet weergegeven) | |||
Regel 1: | Regel 1: | ||
− | I've come across a strange problem (July 2022): I can't just | + | 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). | ||
+ | |||
+ | {| | ||
+ | |[[file:20220802-0946.png|thumb|Test file with at least three different ways to include a tab in a cell. And that's actually not the problem. Copying it, is]] | ||
+ | |[[file:20220802-0947.png|thumb|Test file: Output. Whitespace is made visible here in Sublime Text]] | ||
+ | |} | ||
+ | |||
+ | == Solution: Use 4 spaces == | ||
+ | |||
+ | 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 | ||
+ | * Four spaces seems to be the default value for tab in Sublime Text (eventhough I have a slight preference for 3 spaces). | ||
+ | |||
+ | == Maybe not so bug? == | ||
+ | |||
+ | After all, maybe this isn't a bug? Maybe this doesn't work as I expected, for using tab characters is just so alien of working with spreadsheets? In that case, I should ask myself if I really want to use a spreadsheet for this specific task. | ||
+ | |||
+ | == Sources == | ||
+ | |||
+ | * https://ask.libreoffice.org/t/copy-the-result-of-char-9-of-calc-formula-and-paste-in-libreoffice-calc-basic-ide/65048 |
Huidige versie van 2 aug 2022 om 07:54
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: Use 4 spaces
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
- Four spaces seems to be the default value for tab in Sublime Text (eventhough I have a slight preference for 3 spaces).
Maybe not so bug?
After all, maybe this isn't a bug? Maybe this doesn't work as I expected, for using tab characters is just so alien of working with spreadsheets? In that case, I should ask myself if I really want to use a spreadsheet for this specific task.