#] 
#] *********************
#] "$d_SysMaint"'LibreOffice/Calc formulae - ranges in separate file.txt'  
www.BillHowell.ca 16Nov2017 initial
To view this file - use a text editor (not word processor) constant width font (eg courrier 10), tab - 3 spaces




08********08
#] 31Mar2025 cp Ukrainian city data between LibreCalc files: nyet, move sheets into same file!
see "$d_projMaj"'History/Ukraine-Russia/maps Howell/cities Ukraine github AeroKir post-geany.ods'

=VLOOKUP(A12, 'file:///home/bill/web/ProjMajor/History/Ukraine-Russia/maps Howell/cities Ukraine, simplemaps.com 221 key alphabetically.ods'#$'Ukraine_221_cities', 6, 1)
1 = TRUE
>> how do I stop path from being changed to all-small Letters? 

works for single cell: 
='file:///home/bill/web/ProjMajor/History/Ukraine-Russia/maps Howell/cities Ukraine, simplemaps.com 221 key alphabetically.ods'#$simpleMaps_cities.C72
>> Kherson

!!!???!!! 
cannot have a comma in [fil, dir] names?

I had to add cities 'Ukraine simplemaps.com 221 key alphabetically.ods'
into file			  'cities Ukraine github AeroKir post-geany.ods'
>> then it worked

08********08
#] 16Nov2017 LibreCalc formulae - references to ranges in another file
eg 0_ToDos_month_count.ods

=IF($L5+B$2+1<Today,-99,COUNTIF('file:///media/bill/howell_base/todos/0_todos.ods'#file:///media/bill/howell_base/todos/0_todos.ods,$L5+B$2))

=IF($L5+B$2+1<Today,-99,COUNTIF(#'file:///media/bill/howell_base/todos/0_todos.ods'!period_sel,$L5+B$2))


enddoc