On Mon, Feb 18, 2013 at 5:38 PM, Matthias Johnson < [email protected]> wrote:
> The first part if you go to tools - options - load and save - general. > There are two drop downs one for the document type the second for the > format that a document should default to save in. This stops you from > having to do save as and you can just use save which will default to xls. > There is also a checkbox to suppress the warning that you are saving in a > closed format. > Suite!! That is nice and I have set it - I may have been out of memory earlier - at first, I had no response from Tools/Options either - so I shut it down and re-opened the sheet - and had both the options and access to file/save. I appreciate that direction - and changing the type does help me out. Really, really need a new system that can deal with more than a gig of RAM! It's coming soon. You are correct in that I can't read an ods with an android. Never > tried as I typically save in office formats since many people wouldn't know > what an ods is. > I know what odious is, but not ods. Unless the latter is the former. As for if your install is broken maybe? I can press save as and get a > full list of document formats on mint and windows installs. Can't help > with the formula question though. > Not sure anyone can help ;-) - what I am trying to do is get an average of the data in a column above the row the data is on. The average bit is easy: "-=AVERAGE($D$3:D3)" - That will look odd on the first line, but when you drag it down - say 13 rows, it becomes "=AVERAGE($D$3:D13)" - which is exactly right for row 13 - but if the data in rows 4-13 isn't yet present (this is a mileage comparator/calculator, so until time passes, it won't be), I want to really say "If there is information provided in cell D2, then give me the average, otherwise give me 0" I have temporarily resolved this by the old trick of using a separate column to give me the averages I want - which gradually decrease to nearly 0, then in my visible cells, I just say "=IF(D3,J3,0)" - It's a cheat, but it works. I hate spreadsheets - much prefer databases. Thanks for the save option though! JC > Matthias > > _______________________________________________ > Mid-Hudson Valley Linux Users Group http://mhvlug.org > http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug > > Upcoming Meetings (6pm - 8pm) Vassar College > Feb 6 - Raspberry Pi > Mar 6 - 10th Anniversary Meeting - Linux where you least expect it > Apr 3 - Typography: Physical Art to Digital Art > > -- Eschew obfuscation and pompous prolixity. Light a man a fire, he is warm for the night. Light a man afire, he is warm for the rest of his life.
_______________________________________________ Mid-Hudson Valley Linux Users Group http://mhvlug.org http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug Upcoming Meetings (6pm - 8pm) Vassar College Feb 6 - Raspberry Pi Mar 6 - 10th Anniversary Meeting - Linux where you least expect it Apr 3 - Typography: Physical Art to Digital Art
