Re: [libreoffice-users] Opening .cwk file question
Hi Dennis and all: I suggest you to open the old Mac works file with LibreOffice and save then the spreadsheet as Calc format (.ods) and look if this new spreadsheet keeps show more columns than an usual Calc spreadsheet. Remember that all Calc spreadsheets has a 1024 columns (At least in my version of LibreOffice 4.2.8.2 Ubuntu 14.04 LTS. Newer versions of LibreOffice would have more or less quantity of columns, someone would confirm this issue) Regards, Jorge Rodríguez El 11/10/2017 a las 12:45, romad escribió: I have some old Mac AppleWorks/ClarisWorks files that I wanted to update using LibreOffice Calc. They opened fine but the Calc document has what seems to be an infinite number of columns as no matter how many unwanted columns I delete, they reappear! How do I get Calc to just open the old files without adding empty columns and/or rows? Also, is there a way to limit NEW Calc documents to say, 1 sheet of 10 columns and 100 rows then allow me to delete/add as needed? - Sincerely, Dennis B. Swaney -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Opening .cwk file question
Attached is an example of hiding rows and columns. The list strips attachments, but the example should reach you as you are addressed separately. Blessings, Joe On 10/11/2017 11:45 AM, romad wrote: I have some old Mac AppleWorks/ClarisWorks files that I wanted to update using LibreOffice Calc. They opened fine but the Calc document has what seems to be an infinite number of columns as no matter how many unwanted columns I delete, they reappear! How do I get Calc to just open the old files without adding empty columns and/or rows? Also, is there a way to limit NEW Calc documents to say, 1 sheet of 10 columns and 100 rows then allow me to delete/add as needed? - Sincerely, Dennis B. Swaney -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- A smile - is a sign of joy. A hug - is a sign of love. A laugh - is a sign of happiness. And a friend like me?? ...that's just a sign of good taste!! Blessings, Joe Conner Joshua 24:15 "...as for me and my house, we will serve the LORD." -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Opening .cwk file question
The number of rows and columns is fixed by calc. Deleting rows and/or columns get replaced to maintain the fixed rows and columns. You can however hide rows and columns. Then it looks like they do not exist. Blessings, Joe On 10/11/2017 11:45 AM, romad wrote: I have some old Mac AppleWorks/ClarisWorks files that I wanted to update using LibreOffice Calc. They opened fine but the Calc document has what seems to be an infinite number of columns as no matter how many unwanted columns I delete, they reappear! How do I get Calc to just open the old files without adding empty columns and/or rows? Also, is there a way to limit NEW Calc documents to say, 1 sheet of 10 columns and 100 rows then allow me to delete/add as needed? - Sincerely, Dennis B. Swaney -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- A smile - is a sign of joy. A hug - is a sign of love. A laugh - is a sign of happiness. And a friend like me?? ...that's just a sign of good taste!! Blessings, Joe Conner Joshua 24:15 "...as for me and my house, we will serve the LORD." -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Opening .cwk file question
I have some old Mac AppleWorks/ClarisWorks files that I wanted to update using LibreOffice Calc. They opened fine but the Calc document has what seems to be an infinite number of columns as no matter how many unwanted columns I delete, they reappear! How do I get Calc to just open the old files without adding empty columns and/or rows? Also, is there a way to limit NEW Calc documents to say, 1 sheet of 10 columns and 100 rows then allow me to delete/add as needed? - Sincerely, Dennis B. Swaney -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted