![]() ![]() ![]() Place the cursor in row 12 -> Insert -> Row and all the rows move down, and the highlighting does not change.Ĥ) What happens instead is B13 and D13 lose their highlighting.Ĭd ~/Desktop & wget & localc -nologo 'Conditional formatting example.ods' ods & localc -nologo 'Conditional formatting example.ods' com/ubuntu/ natty/main i386 Packagesģ) What is expected to happen with LibreOffice Calc via the Terminal:Ĭd ~/Desktop & wget https:/ /bugs.launchpad. com/ubuntu/ natty-updates/main i386 Packagesĥ00 us.archive. net/ubuntu/ +source/ libreoffice/ +bug/235602 If correct all those four cells also shall remain green. Now if you insert an empty row inbetween row 11 and 12 you will see that the cells now on row 13 all still equals 1 BUT only two of those cells remain green. Thus the same references as stated for conditions formatting. contents of cell E12 changed from value 1 to the reference =$E$11 contents of cell D12 changed from value 1 to the reference =$D11 contents of cell C12 changed from value 1 to the reference =C$11 ![]() contents of cell B12 changed from value 1 to the reference =B11 The references explicitly given in a cell works and you can check the discrepancy further by replacing the absolute values (1) in cells B12-E12 by a reference to its cells above, i.e No, it still does not work correctly neither for OO nor LO.Ĭell references shall act the same way independent of whether they are specified explicilty in the cell itself or by using conditional formatting.Ī correct result is that all four cells on row 12 remain green when moved to row 13 after you insert an empty row inbetween row 11 and 12. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |