Moving sheets w/o losing formatting

Discuss the spreadsheet application

Moving sheets w/o losing formatting

Postby musictatter » Mon Dec 02, 2019 6:56 pm

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!
Open office 4.16
WIndows 10
musictatter
 
Posts: 4
Joined: Tue May 14, 2019 5:34 pm

Re: Moving sheets w/0 losing formatting.

Postby F3K Total » Mon Dec 02, 2019 7:08 pm

hello,
open source and target document, in source document rightclick on the sheets tab, Move/Copy Sheet...
MCS.png
MCS.png (9.35 KiB) Viewed 208 times
will keep formatting, comments ....
R
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 939
Joined: Fri Dec 16, 2011 8:20 pm

Re: Moving sheets w/0 losing formatting.

Postby musictatter » Mon Dec 02, 2019 7:50 pm

I did that.. Lost all background colors, borders, etc.
Open office 4.16
WIndows 10
musictatter
 
Posts: 4
Joined: Tue May 14, 2019 5:34 pm

Re: Moving sheets w/0 losing formatting.

Postby RoryOF » Mon Dec 02, 2019 8:05 pm

I have just now tested - this kept the formulas and background colours of my original.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29870
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Moving sheets w/0 losing formatting.

Postby Zizi64 » Mon Dec 02, 2019 9:04 pm

I did that.. Lost all background colors, borders, etc.


Please upload two sample files here (to demonstrate the before/after state)
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8521
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Moving sheets w/0 losing formatting.

Postby John_Ha » Mon Dec 02, 2019 9:26 pm

musictatter wrote:[I] 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.
AOO 4.1.6, Windows 7 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.
John_Ha
Volunteer
 
Posts: 6943
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Moving sheets w/0 losing formatting.

Postby RoryOF » Mon Dec 02, 2019 9:29 pm

Would loss of formatting be due to the file format? Save as .ods and try again.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29870
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Moving sheets w/0 losing formatting.

Postby musictatter » Mon Dec 02, 2019 11:44 pm

Because of privacy of the names I'll have to change some things first.
Open office 4.16
WIndows 10
musictatter
 
Posts: 4
Joined: Tue May 14, 2019 5:34 pm

Re: Moving sheets w/0 losing formatting.

Postby RusselB » Tue Dec 03, 2019 4:56 am

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 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
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.
User avatar
RusselB
Moderator
 
Posts: 5667
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: No registered users and 8 guests