I am needing to move a sheet to another file. When I do I lose all the formatting. Background colors, size, comments, etc. Is there a way to save that while moving a sheet?
Added: I am a curator of a cemetery and have created a map with TONS of information. I am learning as I create these sheets. But I need to combine files to simplify the information for future volunteers.
Thank you so much!
Moving sheets w/o losing formatting
-
- Posts: 4
- Joined: Tue May 14, 2019 5:34 pm
Moving sheets w/o losing formatting
Open office 4.16
WIndows 10
WIndows 10
Re: Moving sheets w/0 losing formatting.
hello,
open source and target document, in source document rightclick on the sheets tab, Move/Copy Sheet... will keep formatting, comments ....
R
open source and target document, in source document rightclick on the sheets tab, Move/Copy Sheet... will keep formatting, comments ....
R
- MMove 1.0.6
- Extension for easy, exact positioning of shapes, pictures, controls, frames ...
- my current system
- Windows 10 AOO, LOLinux Mint AOO, LO
-
- Posts: 4
- Joined: Tue May 14, 2019 5:34 pm
Re: Moving sheets w/0 losing formatting.
I did that.. Lost all background colors, borders, etc.
Open office 4.16
WIndows 10
WIndows 10
Re: Moving sheets w/0 losing formatting.
I have just now tested - this kept the formulas and background colours of my original.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Moving sheets w/0 losing formatting.
Please upload two sample files here (to demonstrate the before/after state)I did that.. Lost all background colors, borders, etc.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Moving sheets w/0 losing formatting.
musictatter wrote: have created a map with TONS of information.
If you have tons of information a database may be a better solution.
If you persist with a spreadsheet you find it sensible to protect some? many? all? cells with data against change.
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Moving sheets w/0 losing formatting.
Would loss of formatting be due to the file format? Save as .ods and try again.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 4
- Joined: Tue May 14, 2019 5:34 pm
Re: Moving sheets w/0 losing formatting.
Because of privacy of the names I'll have to change some things first.
Open office 4.16
WIndows 10
WIndows 10
Re: Moving sheets w/0 losing formatting.
While you're anonymizing the data, help for which can be found in [Forum]How to attach a document also please note that we don't need all of the spreadsheet, just enough that the sheet you upload also shows the same problem.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.