[Solved] Move copy in Calc

Discuss the spreadsheet application

[Solved] Move copy in Calc

Postby djcabc » Fri May 03, 2019 9:21 pm

I use Microsoft Windows 7 for the Apache OpenOfffice Calc spreadsheet. I have 100 individual sheets on the spreadsheet, with the individual names on the scroll bar. When i fill a sheet, I copy it and rename it as (2), with the original sheet renamed (1). After several "copies", I am no longer able to copy more sheets. On the "Edit" button, the "Copy/Move" action is in light gray, while the allowed actions are in black. How do I free up the "copy/move" action, so I can continue to copy?
Last edited by djcabc on Fri May 03, 2019 11:23 pm, edited 1 time in total.
OpenOffice 3.1 on Windows 7
djcabc
 
Posts: 1
Joined: Fri May 03, 2019 8:39 pm

Re: Move copy in Calc

Postby UnklDonald418 » Fri May 03, 2019 11:00 pm

Welcome to the forum.
the "Copy/Move" action is in light gray

That indicates you have reached the limit on the number of sheets in that document, so you will need to start a new document.
I'm not sure what the limit is for OO version 3.1 (it was upgradeded in 2010) but I just tested version 4.1.6 and the limit is 256 sheets.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1194
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 18 guests