Cut/Paste will leave the cut cell without style

Discuss the spreadsheet application
Post Reply
openofficedifficult
Posts: 14
Joined: Tue Feb 06, 2018 8:52 pm

Cut/Paste will leave the cut cell without style

Post by openofficedifficult »

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
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
robleyd
Moderator
Posts: 5087
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Post by robleyd »

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
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Post by Villeroy »

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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
robleyd
Moderator
Posts: 5087
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Post by robleyd »

I agree, but
I have to manually enther the style again
is what I took to possibly be direct formatting.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Post Reply