Re: [libreoffice-users] Re: Calculating the Nth weekday of a month.

2017-10-11 Thread Mike Adams
Given Calc where DATE(,MM,DD) and WEEKDAY(X) results 1 = Sunday, 2 = Monday ... 6 = Friday, 7 = Saturday. Solve for the first week of the month (WD = 1) Variables = 2017 desired year, MM = 10 = desired month, d1 = 1 = First day of the month WC = 3 = Weekday code for Tuesday WD = 1 = Week

Re: [libreoffice-users] Opening .cwk file question

2017-10-11 Thread jorge Rodríguez
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

Re: [libreoffice-users] Opening .cwk file question

2017-10-11 Thread Joe Conner
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

Re: [libreoffice-users] Opening .cwk file question

2017-10-11 Thread Joe Conner
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

[libreoffice-users] Opening .cwk file question

2017-10-11 Thread romad
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

Re: [libreoffice-users] adding / using custom colours to LibreOffice

2017-10-11 Thread Toki
On 10/11/2017 02:48 PM, Gary Dale wrote: > Either way, with that many palettes in play, there should be a way to manage > them other than fiddling with XML files. Palettes are function specific. As such, if made according to the user specifications, there is no legitimate reason to change

Re: [libreoffice-users] adding / using custom colours to LibreOffice

2017-10-11 Thread Gary Dale
On 10/10/17 10:34 AM, Tim-L wrote: On 10/10/2017 04:23 AM, Toki wrote: On 10/10/2017 03:38 AM, Gary Dale wrote: I agree that storing organizational (not necessarily corporate) colours in "custom" may not always be the best idea, but given their small number in any rational organization,