[Solved] OpenOffice copying info onto multiple pages

Discuss the spreadsheet application

[Solved] OpenOffice copying info onto multiple pages

Postby bdf1215 » Tue Dec 31, 2019 3:03 am

Hi everyone,

I'm having a problem on multiple computers as following:

After a spreadsheet has been open on Calc for some time, it starts exhibiting the following behavior:

1. Copy some text (good)
2. Paste text in a different location on that page (good)
3. Find that the program has copied information onto a separate page, potentially overwriting the data already present (not good)

It has happened with .ods and .xls files. It has only started happening recently and I'd prefer not to have to switch platforms to keep records, but large chunks of data are being destroyed and I can't have that.

I'm including a sample file to help give an idea of the issue, though the actual file is much larger and contains copyrighted information.

Thanks in advance for your help!
Attachments
Sample.ods
Tagges ✓ [Solved]
(17.63 KiB) Downloaded 23 times
Openoffice 4.1.6 on Windows 7, 10
bdf1215
 
Posts: 5
Joined: Tue Dec 31, 2019 2:52 am

Re: Bug- Openoffice copying info onto multiple pages

Postby RusselB » Tue Dec 31, 2019 4:08 am

Welcome to the Forums.
The situation you have described is usually due to the Ctrl key being depressed/stuck when selecting another page for the pasting process.
This makes it a keyboard problem, not a software one.
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: 6097
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Bug- Openoffice copying info onto multiple pages

Postby MrProgrammer » Wed Jan 01, 2020 8:41 am

bdf1215 wrote:I'm including a sample file to help give an idea of the issue …
If you claim that this is a bug, provide the exact steps needed to reproduce the problem using your attachment.

bdf1215 wrote:Find that the program has copied information onto a separate page, potentially overwriting the data already present (not good)
If one has accidentally selected multiple sheets, which you seem to be calling "pages", a Paste operation changes all of them. This is normal operation for the program. One can select/unselect sheets on their sheet tab by using ⌘+click on a Mac, Ctrl+click on other platforms.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3960
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: [Solved] OpenOffice copying info onto multiple pages

Postby bdf1215 » Tue Jan 14, 2020 6:47 pm

That was it, user error, thank you. Turns out I was using an incorrect shortcut to switch between sheets, by hitting Ctrl-Shift-PgUp/Dn instead of just Ctrl-PgUp/Dn.

Just as a side note, I think having the sheets light up in blue like when selecting multiple cells (rather than white vs. off-white) would help clarify things visually.

Thank you both for your time!
Openoffice 4.1.6 on Windows 7, 10
bdf1215
 
Posts: 5
Joined: Tue Dec 31, 2019 2:52 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 12 guests