[libreoffice-users] Question on better way for forumula with ods that auto imports csv file.

Have a spreadsheet that imports data from a csv file into columns 
A, B, C.
Have various formulas in D thru J. Originally had it reference to 
cell using column with number. This worked, but found if would 
open sheet again with more lines in A,B, and C. That the last 
formulas would have the row number offset by the lines added in 
import. Only way I found to get it to always work is using the 
indirect option? Otherwise the copy of formulas would have 
incorrect rows.

=IF(AND(INDIRECT("B"&ROW())>10,INDIRECT("B"&ROW()-1)>0
),INDIRECT("A"&ROW())-INDIRECT("A"&ROW()-1),0)


+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy