Paste Special Options Missing - English - Ask LibreOffice
Jul 16, 2025 · Hi @ LibreOffice Community For years I have been using LO Calc and have been used to copying a column of numbers and pasting them into another column which contains formula and …
Libre Calc, How to convert a vertical line of data into horizontal one ...
Nov 3, 2023 · I need help to convert a vertical line of data in a row to columns. It involves about 60 items with 14 rows each, to 14 columns with 60 rows. which change daily. I will label and format it once the …
Making Rows for Horizontal Pasting Inside a Single Text Box?
Dec 16, 2021 · Data>Text to columns … [OK] In this special situation, it splits the text rows in separate rows rather than columns. Copy, Paste-Special with transpose option.
Calc: Transpose Fails if Freeze Rows & Columns Set
Jan 5, 2020 · Optionally clear the previous test by undoing the transpose step or start over and get to the step where we enter the transpose () function. Pick some random cell, say C12, and freeze …
How do I convert rows into columns (or vice versa) in Calc?
Feb 1, 2014 · I have some data spread out in rows. Now I’ve entered it, I really would prefer to see it in columns. Is there a way to do this automatically in Calc (i.e., change a row presentation into …
Calc crashes when transposing - English - Ask LibreOffice
May 19, 2020 · Just checked - the range of 3 columns of 800 rows is transposed both through the PasteSpecial and through the formula {=TRANSPOSE (A1:C800)} well. What is your OS?
How to transpose one column into multiple row - Ask LibreOffice
May 9, 2019 · Hey, I have a lot of numbers (25344) in one column and i want to transpose it into rows, where i want to start new row after every 8 number. How can i do this? Like ...
Import PDF table into Calc - English - Ask LibreOffice
Jun 18, 2024 · I have read a number of answers but am still confused. I have four column PDF table I want to put in Calc. Waht are the exact steps I need to use e.g. what application do I open the PDF …
Paste special transpose function missing in 6.0.4
Jun 14, 2018 · Hi David. I have to transpose columns to rows. I made a trial and copied columns in CALC, transposed them and then I pasted back the row as unformatted text in Writer. Then I …
Transpose sequences of rows into columns, ending with one row per ...
Feb 11, 2022 · Hello, I’ve searched in both the answers and the documentation, but I can’t find a reasonably automated procedure for this: I need to transpose rows, which belong together, into …