Cut/Paste will leave the cut cell without style

Discuss the spreadsheet application

Cut/Paste will leave the cut cell without style

Postby openofficedifficult » Thu Mar 08, 2018 8:04 pm

When I Cut/Paste to another cell it will leave the cut cell without style.
So then I have to manually enther the style again every time for one single cell when I cut and paste and then want to enter text in the cut cell to make it look like all the other cells. Is this normal behaviour an if so is there a setting which will keep the cell format after cutting the cell?
OpenOffice 4.1.3 on Windows 7
openofficedifficult
 
Posts: 14
Joined: Tue Feb 06, 2018 8:52 pm

Re: Cut/Paste will leave the cut cell without style

Postby Villeroy » Thu Mar 08, 2018 8:35 pm

Copy the cell and hit the Backspace key to clear the content.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25954
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Cut/Paste will leave the cut cell without style

Postby robleyd » Fri Mar 09, 2018 1:02 am

Your description suggests you are using direct formatting on your cells; consider creating a style, or styles which will allow you to quickly format a cell or series of cells via the Styles and Formatting window.
Cheers
David
Apache OpenOffice 4.1.6 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2244
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Cut/Paste will leave the cut cell without style

Postby Villeroy » Fri Mar 09, 2018 11:36 am

robleyd wrote:Your description suggests you are using direct formatting on your cells;

No, he noticed that the cell style is moving away with a moved cell (falling back to "Default") which can be perceived as inconsistent.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25954
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Cut/Paste will leave the cut cell without style

Postby robleyd » Fri Mar 09, 2018 1:05 pm

I agree, but
I have to manually enther the style again

is what I took to possibly be direct formatting.
Cheers
David
Apache OpenOffice 4.1.6 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2244
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: MrProgrammer and 25 guests