Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Preventing unwanted column creation.
Preventing unwanted column creation.
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
bryoman
Sentinel


Joined: Jan 07, 2009
Posts: 27
Location: Carlisle, England

PostPosted: Mon Dec 24, 2012 11:14 am    Post subject: Preventing unwanted column creation.

Another basic question...

If I stray to the right in a Calc document, beyond my data, the thing "helpfully" creates new columns, apparently unto the end of space/time.

The mere thought of all these unwanted and unrequested empty columns existing "out there" into the void nearly drives me nuts... No, really - it does. And can I then "get rid" of them? No I can't... apparently.

So can I prevent Calc from creating these in the first place, and LIMIT my spreadsheet to the columns *I actually want*?? Can't see how to do it.

Same applies to rows, of course, in the other direction.

Don't tell me I can 'hide' them, or something - I want them never to exist in the first place! Wink

Thanks for advice...
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Mon Dec 24, 2012 11:34 am    Post subject: Re: Preventing unwanted column creation.

bryoman wrote:
The mere thought of all these unwanted and unrequested empty columns existing "out there" into the void nearly drives me nuts... No, really - it does. And can I then "get rid" of them? No I can't... apparently.


You are making some incorrect assumptions about how Calc files are stored. When you save a Calc files, the data that is stored as a list of only cells with actual content (also known as a "sparse list"). Empty cells do not exist in a Calc file so what you are seeing on screen are non-existing cells that you may potentially use.

In other words, there are no "resources" being wasted when you scroll past the range of existing, used cells. Even filling a cell in the bottom-right-most cell only creates one cell in your Calc file.

BTW, if you accidentally scroll out too far, you can jump back to the last non-empty cell by pressing the Command-left or Command-up arrows.

Patrick
Back to top
bryoman
Sentinel


Joined: Jan 07, 2009
Posts: 27
Location: Carlisle, England

PostPosted: Mon Dec 24, 2012 11:57 am    Post subject: Re: Preventing unwanted column creation.

Quote:
You are making some incorrect assumptions about how Calc files are stored. When you save a Calc files, the data that is stored as a list of only cells with actual content (also known as a "sparse list"). Empty cells do not exist in a Calc file so what you are seeing on screen are non-existing cells that you may potentially use.

In other words, there are no "resources" being wasted when you scroll past the range of existing, used cells. Even filling a cell in the bottom-right-most cell only creates one cell in your Calc file.

BTW, if you accidentally scroll out too far, you can jump back to the last non-empty cell by pressing the Command-left or Command-up arrows.

Patrick


OK - many thanks, Patrick - I think it's more the sight of all these columns, rather than them being actually using resources, than grates with me. I'll learn to live with them now!

Thanks for your invaluable help in 2012 - and can I wish you (and all our community) a peaceful Festive Season, and more peace in 2013.

Jeremy R.
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.