I can do this in excel, (excel instructions below) but I need to do this functionality in Calc and I’m hoping someone knows how to do this. What I have is a workbook with 20+ sheets, with hundreds of named cells/ranges. I make a duplicate of that workbook, so the duplicate has all the same named cells/ranges in it. I then continue with the original workbook and make a new sheet with all kinds of references and calculations in that reference all kinds of different cells and ranges of the original workbook.
Now that new sheet in the original workbook is the way I like it. I want to copy that new sheet into the new workbook with the exact same characters and formulas that I typed into that sheet into the original workbook. I DO NOT WANT THE VALUES, I DO NOT WANT TO REFERENCE THE ORIGINAL WORKBOOK. I simply want whatever I typed into sheetxxx cell xy to be repeated exactly as I typed it into cell xy of sheetxxx of the new workbook. Below is the “trick” that you can do in excel to accomplish this because for god knows what reason I can’t copy and paste the text of multiple cells from one workbook into another. I want to be able to do this in Calc.
In both programs, I can go to an individual cell, hit F2, and then copy (^A,^C) the text of the cell, and then go to the new workbook, hit F2 in the corresponding cell and then paste (^V) and do this for all cells, but this is a pain in the neck.
So How can I do this in one shot in libreoffice Calc?
Tia, Jleslie48
excel instructions:
in excel Making An Exact Copy Of A Range Of Formulas using Notepad.
Here’s how it works:
Put Excel in formula view mode. The easiest way to do this is to press Ctrl+` (that character is a “backwards apostrophe,” and is usually on the same key that has the ~ (tilde).
Select the range to copy.
Press Ctrl+C
Start Windows Notepad
Press Ctrl+V to past the copied data into Notepad
In Notepad, press Ctrl+A followed by Ctrl+C to copy the text
Activate Excel and activate the upper left cell where you want to paste the formulas. And, make sure that the sheet you are copying to is in formula view mode.
Press Ctrl+V to paste.
Press Ctrl+` to toggle out of formula view mode.
Note: If the paste operation back to Excel doesn’t work correctly, chances are that you’ve used Excel’s Text-to-Columns feature recently, and Excel is trying to be helpful by remembering how you last parsed your data. You need to fire up the Convert Text to Columns Wizard. Choose the Delimited option and click Next. Clear all of the Delimiter option checkmarks except Tab.