[users] Re: limit # of columns in a spreadsheet
Alan, I did as you suggested (twice). All the hundreds of columns highlight in blue, and I delete them, and they turn white but don't go away. However, I have learned that if I convert the spreadsheet to a google doc first, I can then upload it to GDocs. When I convert it go a google doc, that conversion strips out the unused columns. Under File in LibreOffice, then Google Docs which has a sub-item called Export to Google Docs So the question has become academic, but I'm still baffled as to why I can't do this if OO or Libre. Thanks to all. Helen On Fri, Jul 1, 2011 at 1:32 AM, Alan Boba abo...@gmail.com wrote: On Thu, Jun 30, 2011 at 12:54 PM, Helen etter...@gmail.com wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 You may wish to try - select the first column to the right of your last column - select all the remaining columns to the right, Ctrl+Shift+rightArrow - delete the selected columns, rightClick on any selected column header and click Delete columns - save the spreadsheet and now try to import to GDocs If spreadsheet has had any row based formatting applied, even formatting that isn't apparent without contents in cells, e.g. Italic, this expands the column range to all columns as far as tracking properties of spreadsheet cells go. This is true even though Ctrl+End won't take you to the right most column. It will take you only to the right most non-blank column. Don't know if this is the root of your problem but have found row or column based formatting that continues far beyond the bounds of the data range often caused unexpected behavior in my spreadsheets. Discovered this MANY moons ago with 1-2-3, Windows version, and have found it true in every version of QuattroPro, Excel and Calc since then. -- Helen Etters using Linux, suse11.4 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
On Fri, Jul 1, 2011 at 7:48 AM, Helen etter...@gmail.com wrote: Alan, I did as you suggested (twice). All the hundreds of columns highlight in blue, and I delete them, and they turn white but don't go away. However, I have learned that if I convert the spreadsheet to a google doc first, I can then upload it to GDocs. When I convert it go a google doc, that conversion strips out the unused columns. Under File in LibreOffice, then Google Docs which has a sub-item called Export to Google Docs So the question has become academic, but I'm still baffled as to why I can't do this if OO or Libre. Thanks to all. Helen On Fri, Jul 1, 2011 at 1:32 AM, Alan Boba abo...@gmail.com wrote: On Thu, Jun 30, 2011 at 12:54 PM, Helen etter...@gmail.com wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 You may wish to try - select the first column to the right of your last column - select all the remaining columns to the right, Ctrl+Shift+rightArrow - delete the selected columns, rightClick on any selected column header and click Delete columns - save the spreadsheet and now try to import to GDocs If spreadsheet has had any row based formatting applied, even formatting that isn't apparent without contents in cells, e.g. Italic, this expands the column range to all columns as far as tracking properties of spreadsheet cells go. This is true even though Ctrl+End won't take you to the right most column. It will take you only to the right most non-blank column. Don't know if this is the root of your problem but have found row or column based formatting that continues far beyond the bounds of the data range often caused unexpected behavior in my spreadsheets. Discovered this MANY moons ago with 1-2-3, Windows version, and have found it true in every version of QuattroPro, Excel and Calc since then. -- Helen Etters using Linux, suse11.4 Helen, I guess I should have been more clear. What you experienced is what I expected, the columns don't go away as you found. What does happen though is non default attributes are removed from all the cells. So even though the spreadsheet still displays all the columns it's internal map (don't know the correct term here) of what cells have non default attributes is reduced. I'm curious did you try and import a spreadsheet after deleting columns and saving? Or did my lack of explaining the expected outcome (at least to me) of the delete columns operation keep you from giving it a shot? If the latter happened perhaps you would try importing one of those spreadsheets where you deleted columns and let me know if it works? No sense offering advise that doesn't resolve the issue. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
On 06/30/2011 09:54 AM, Helen wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 LO mailing lists are here: http://www.libreoffice.org/get-help/mailing-lists/ openSUSE support for LO is here: http://en.opensuse.org/LibreOffice -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
On 6/30/2011 9:54 AM, Helen wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 QUESTION: If you open your document and then simultaneously press the two keys CTRL + END what column/row receives the focus? Joe Conner, Poulsbo, WA USA -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
It scoots over to column S. On Thu, Jun 30, 2011 at 1:19 PM, JOE Conner joeconner2...@gmail.com wrote: On 6/30/2011 9:54 AM, Helen wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 QUESTION: If you open your document and then simultaneously press the two keys CTRL + END what column/row receives the focus? Joe Conner, Poulsbo, WA USA -- --**--**- To unsubscribe send email to users-unsubscribe@openoffice.**orgusers-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- Helen Etters using Linux, suse11.4 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
On 6/30/2011 10:35 AM, Helen wrote: It scoots over to column S. On Thu, Jun 30, 2011 at 1:19 PM, JOE Conner joeconner2...@gmail.com mailto:joeconner2...@gmail.com wrote: On 6/30/2011 9:54 AM, Helen wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 QUESTION: If you open your document and then simultaneously press the two keys CTRL + END what column/row receives the focus? Joe Conner, Poulsbo, WA USA Helen Etters using Linux, suse11.4 Then I cannot help you and my idea that there may be an active cell out of range does not work. Joe -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
OK - thanks for trying. I clearly have a hundred or so columns that I don't know how to delete. Thanks for the try! H. On Thu, Jun 30, 2011 at 2:23 PM, JOE Conner joeconner2...@gmail.com wrote: On 6/30/2011 10:35 AM, Helen wrote: It scoots over to column S. On Thu, Jun 30, 2011 at 1:19 PM, JOE Conner joeconner2...@gmail.commailto: joeconner2007@gmail.**com joeconner2...@gmail.com wrote: On 6/30/2011 9:54 AM, Helen wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 QUESTION: If you open your document and then simultaneously press the two keys CTRL + END what column/row receives the focus? Joe Conner, Poulsbo, WA USA Helen Etters using Linux, suse11.4 Then I cannot help you and my idea that there may be an active cell out of range does not work. Joe -- --**--**- To unsubscribe send email to users-unsubscribe@openoffice.**orgusers-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- Helen Etters using Linux, suse11.4 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
i sometimes have that problem with ms excel also. i just copy and paste my original data rows and columns into a new spreadsheet - then delete the old one. never understood why this happens. On Thu, Jun 30, 2011 at 10:35 AM, Helen etter...@gmail.com wrote: It scoots over to column S. On Thu, Jun 30, 2011 at 1:19 PM, JOE Conner joeconner2...@gmail.comwrote: On 6/30/2011 9:54 AM, Helen wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 QUESTION: If you open your document and then simultaneously press the two keys CTRL + END what column/row receives the focus? Joe Conner, Poulsbo, WA USA -- --**--**- To unsubscribe send email to users-unsubscribe@openoffice.**orgusers-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- Helen Etters using Linux, suse11.4 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
How do you prevent the new spreadsheet from creating infinite columns? Seems all my OO (and libre) spreadsheets take the default of infinite columns. On Thu, Jun 30, 2011 at 3:54 PM, Debra Barringer budsran...@gmail.comwrote: i sometimes have that problem with ms excel also. i just copy and paste my original data rows and columns into a new spreadsheet - then delete the old one. never understood why this happens. On Thu, Jun 30, 2011 at 10:35 AM, Helen etter...@gmail.com wrote: It scoots over to column S. On Thu, Jun 30, 2011 at 1:19 PM, JOE Conner joeconner2...@gmail.comwrote: On 6/30/2011 9:54 AM, Helen wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 QUESTION: If you open your document and then simultaneously press the two keys CTRL + END what column/row receives the focus? Joe Conner, Poulsbo, WA USA -- --**--**- To unsubscribe send email to users-unsubscribe@openoffice.**orgusers-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- Helen Etters using Linux, suse11.4 -- Helen Etters using Linux, suse11.4 -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
On Thu, Jun 30, 2011 at 4:46 PM, Helen etter...@gmail.com wrote: How do you prevent the new spreadsheet from creating infinite columns? Seems all my OO (and libre) spreadsheets take the default of infinite columns. You see infinite columns but the actual number of columns in the OOo sheet is determined by the last column that has data in it. You can determine the last cell by doing a ctrl (or cmd on Mac) - end. Since google seems to see more cells in the sheet, why don't you just open a new sheet in google docs, then select all active cells in your OOo sheet, copy them, then past them into the google docs sheet? -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: limit # of columns in a spreadsheet
On Thu, Jun 30, 2011 at 12:54 PM, Helen etter...@gmail.com wrote: I have a spreadsheet with 14 columns. I tried to upload it to google docs, and got a message saying the document has too many columns, that google has a limit of 219 columns. So I opened my document and I see that the columns just go on and on forever. I need only the fourteen that I'm using. But I don't find how to tell my document that it has only14 columns. As I look through my other files, I see that this seems to be true of all my spreadsheets -- that the columns just go on forever. How do I control how many columns it should have? Thanks very much, Helen, using LibreOffice 3.3.1 in Suse 11.4 You may wish to try - select the first column to the right of your last column - select all the remaining columns to the right, Ctrl+Shift+rightArrow - delete the selected columns, rightClick on any selected column header and click Delete columns - save the spreadsheet and now try to import to GDocs If spreadsheet has had any row based formatting applied, even formatting that isn't apparent without contents in cells, e.g. Italic, this expands the column range to all columns as far as tracking properties of spreadsheet cells go. This is true even though Ctrl+End won't take you to the right most column. It will take you only to the right most non-blank column. Don't know if this is the root of your problem but have found row or column based formatting that continues far beyond the bounds of the data range often caused unexpected behavior in my spreadsheets. Discovered this MANY moons ago with 1-2-3, Windows version, and have found it true in every version of QuattroPro, Excel and Calc since then. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help