I know it should have worked in the original but it didn't, even checked the formula for the cell and it was correct just the result was wrong. It's just a simple time sheet multiplying number of hours worked by rate (which is an absolute address), the column works fine except for one cell in the original file! :roll: :roll:Īll the columns are filled down and work fine, just a strange one! Just put the formula in manually for the cell and it then works fine. Still not sorted, made the SSheet up again in a new file, filled formulae down and it works fine!! It is hard, but I'm still managing to resist the temptation - taking it one day at a time though. The big new feature is the ability to edit PDF files - which wrecks the intention of PD Format. Unlike Office 2007 OOo havenot gone for an interface change just to upset people - it still looks the same as 2.3/2.4 (OK one had a blue taskbar and the other has an orange one but that's it). Just wondering if anyone has noticed anything similar, please do not forward cheques, cash etc in sympathy !!:lol:Īnd in a coupleof weeks there will be a new, new version - Open Office 3. Yes I know there's a new version!!! :twisted: :twisted: :lol: but hope to give PC a heart transplant soon so not upgrading now. It's only a series of 40, and 10 columns. The function returns then the value in a row of the array, named in the Index, in the same column. This function verifies if the first row of an array contains a certain value. Have to format the cell to HH:MM:SS myself to correct it so the formula is correct just the cell doesn't take the format applied to the full column. Searches for a value and reference to the cells below the selected area. įroze row 3, filled in the required formulae in row 4, filled the columns down, other columns filled ok, the cells below are ok and the series continues on correctly. I have the column "centered", formatted to HH:MM:SS, and when the series fails in the cell, the text is aligned left and my total then shows #ref#, so I know immediately something is wrong. Topic: Almost OpenOffice Posted By: househunterĪm running OO 2.3, using Calc, when I go to "fill series down" using Absolute Reference the column fills down with the formula but.Īround midway down the column the formula goes astray in one of the cells :cry: Now it's not a major problem and can spot it immediately if it's not correct but just wondering if anyone has noticed anything similar. View The Full Original Topic: Almost OpenOffice Join our free community to post questions, replies or to see the full features of the forum. This is a text archive version of our main content.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |