for a decimal point and the, for delimiter.Īttached is the screen that comes up for importing the. Maybe I've changed a setting somewhere but have not found any thing. There are no single quotes in the two files. The single quotes are telling Calc that the cell contains text not numbers! My question is why should it think they are text and not numbers? It is is happening in both files - notice the two numbers on the first row of data for the mat_fmt.csv. I've edited here to show the single quotes that are in each cell. When I load the mat_fmt.csv file, the contents of the first four rows are: Columns are all 'Standard' and the TAB and Comma delimiters are selected. I load the files and the standard Text Input dialog comes up for the. (669 Bytes) Downloaded 110 times mat_fmt.csv This should graph OK. TVU_fmt.csv This file won't graph for me. The mat_fmt.csv will graph for me but the tvu_fmt.csv will not. That, to me, says Calc is not handling the large number of digits in some way. The values are integers and floats (to double-precision some with exponents). I've tried resaving from Calc with no change. Three hundred to several thousand lines - some work some don't. No obvious differences with different size. csv files and have not found any thing unusual in text or hex. If I try to do it manually from the insert menu I get the same results. The Categories ( or Data Labels) box on the Data Series tab contains the last row of the input columns. If I check the Data Range it is blank, there are no Data Series. Starting today, Windows did update last night, some files don't seem to be handling the input columns properly. That is usually sufficient for what I'm doing. Select first column and one or more other columns.Ĭlick the graph icon to bring up the dialog. Most files are generated by FORTRAN test programs some from Matlab and a few by hand in VIM. Today, some files act really strange and others are OK. csv files and generating quick plots for weeks with no problems. Can someone please clue me in as to how to specify a cell address based upon the value in another cell or as a computed result. However, I am at a loss to find such functionality in Calc. I used to do such things with Supercalc for DOS 20+ years ago. in a function of some sort) as "C" and the value in cell X1. I need to place in cell Y1 the value of cell C8 which I wish to specify programatically (i.e. I have the idea that I can easily produce a column containing the desired row values 8, 15, 22, 29 etc. So I need to produce a concurrent block of data containing the contents of C8, C15, C22, C29 etc. I wish to graph only the week ending values (Friday). I have a spreadsheet containing daily data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |