| View previous topic :: View next topic |
| Author |
Message |
Leaskovski
Guest
|
 Posted: Thu Apr 22, 2004 11:26 am Post subject: Adding a sheet |
 |
|
Hi all,
Simple problem. I am trying to add a sheet to my sxc file. The only problem is that when i right click on the sheet tabs at the bottom there is no 'insert sheet'. Also when i click on the 'insert' menu, 'sheet' is greyed out.
Any answers???
Cheers |
|
| Back to top |
|
 |
erikanderson3
OOo Advocate
Joined: 25 Feb 2004
Posts: 332
Location: San Francisco peninsula
|
| Posted: Thu Apr 22, 2004 6:36 pm Post subject: |
|
|
Was your spreadsheet originally imported from an Excel doc, by any chance? I once had an Excel import that wouldn't save cleanly, saying it had too many sheets, but it only had 16. I just experimented with a pure Calc file and added 30 sheets, and it saved no problem. Makes me think the Excel converter might have an issue or two.
Cheers,
Erik |
|
| Back to top |
|
|
Iannz
OOo Advocate
Joined: 14 Feb 2004
Posts: 494
Location: Christchurch, New Zealand
|
| Posted: Thu Apr 22, 2004 6:57 pm Post subject: |
|
|
Another possibility is that the file is read-only. Try clicking on the "Edit file" button in the function bar (by default just to the right of the "save" button.
_________________
Cheers, Ian
http://wiki.services.openoffice.org/wiki/Extensions_development_basic a wiki about writing OpenOffice.org extensions. |
|
| Back to top |
|
|
Leaskovski
Guest
|
| Posted: Thu Apr 22, 2004 10:00 pm Post subject: |
|
|
| erikanderson3 wrote: | Was your spreadsheet originally imported from an Excel doc, by any chance? I once had an Excel import that wouldn't save cleanly, saying it had too many sheets, but it only had 16. I just experimented with a pure Calc file and added 30 sheets, and it saved no problem. Makes me think the Excel converter might have an issue or two.
Cheers,
Erik |
Yeap, converted from an xls file. Okay shall recreate it from a new spreedsheet.
Cheers, |
|
| Back to top |
|
|
|
