/media/bill/HOWELL_BASE/System_maintenance/LibreOffice/macros_ToDos.txt



***************
17Jan2017 Test broken "Update" macro : 

$  Click, AFTER cleaning up range names
"... 
BASIC runtime error.
An exception occurred 
Type: com.sun.star.uno.RuntimeException
Message: .
..."
>> stops at line:  
oCell  = oSheet.getCellRangeByName("Today")
leads to :  oCell.Value = svc.callFunction("MAX",arg)
WRONG - this is the destination cell!  "Today" should be range of "Date" in "TimeLog" ? 
it does refer to a range Today : $Todos.$D$5:$D$4654
"=MAX($TimeLog.C5:C4654)"  works, so redefine Today!
$ Click "update" again
"...
BASIC runtime error.
Property or method not found: Value.
..."
>>  ".Value" & ".value" work elsewhere, why not here?
"svc.callFunction" not used elsewhere! 
Oops - Today referred to column "D" not "C"
$ fix and Click "update" again
nyet 
$ reset "Today" to single cell TimeLog.J10,  Click "update" again

NOW IT WORKS!!!!

Not needed : 
"Todayer" should be single cell
cell_date_today      = oSheet.GetCellRangeByName("Todayer")
date_today      = cell_date_today.Value
it does refer to a single cell : Todayer  $Todos.$O$2


****************
17Jan2017 Fix-up of broken "Update" macro

Ranges  as of 17Jan2017, cols & rows may change with insertions!  : 

Date 		$Todos.$D$5
date_chgs	$Todos.$J$5
Date_end	$TimeLog.$O$2
Date_start	$TimeLog.$O$1
Dates		$Todos.$D$5:$D$191
dates_Old	$Todos.$Q$5:$Q$191
Dates_timeLog	$TimeLog.$C$5:$C$4654
Day_of_week	$'Months Days'.$J$5:$K$12
Dayer		$Todos.$E$5:$E$191
Days_in_Months	$'Months Days'.$B$6:$D$17
Drumheller_exercise	$Todos.$Q$3
Drumheller_shop	$Todos.$Q$4
haircut		$Todos.$O$3
longTerm	$Todos.$P$1
MomDad_visit	$Todos.$Q$2
Month_number	$'Months Days'.$F$5:$H$17
Period_sel	$Todos.$I$5:$I$191
priority	$Todos.$C$5
Pubs_ToDOs	$'Publications IJCNN2017'.$A$2:$Q$34 leave - might use later?
Timesheet	$TimeLog.$A$5:$AC$4654
Today		$TimeLog.$J$10			corrected!
Todayer		$Todos.$O$2			??error?
ToDos		$Todos.$A$5:$Q$191
ToDos_sortRange	$Todos.$A$5:$Q$191


+-----+
Deleted unused ranges : 

Macro does these so not needed (range names not in macro nor in sheet): 
Date -  seems redundant but leave in for now (use Dates?)
Dates_long -  "longTerm" is now range name
Date_year 
Dayer ($Todos.$E$5:$E$191) - "Todayer" cell title?? rather than date!
stopper ($Todos.$M$2) - deleted as not in [formulae, macros], nothing in cell
week ($Todos.$C$1:$C$5) ??looks useless, Day_of_week is used


Error in range specified?
Todayer - at Summary Date_end, used in "Sub color_date ()"
!!!!AH-HAH!!!  - key error!
I put formula in cell "=Today()"


These are defined in summary spreadsheet 
- used for defining period of analysis :
Date_end
Date_start

Other : 
Day_of_week ($'Months Days'.$J$5:$K$12) - used in "ToDos" sheet, "Day" column


enddoc