Ive just double-checked - it should work with a current LO version, tested on Ubuntu LInux as well as Win7.If I follow exactly your instructions, LO fills each row after the selection.
Dont really know what could be the problem (LO version 4.3.3.2 on Debian). ![]() You can also do it by double-clicking on the bottom-right corner of the cell containing the average formula (in this example, B2). Provide details and share your research But avoid Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. Not the answer youre looking for Browse other questions tagged libreoffice-calc or ask your own question. Press question mark to learn the rest of the keyboard shortcuts Log In Sign Up User account menu 5 Trying to get no fill color for empty cells. That makes it much easier for people to help you:-) I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. Share Report Save level 1 Original Poster 1 year ago edited 1 year ago Because I cant make a message for link posts: Ive been teaching myself libre office for a while now and its been super intuitive. Everything I need to do (With some exceptions) has been possible and relatively easy to figure out. Today Im trying to make my cell backgrounds in calc change color depending on the value of the cell. I made this work to great success, however now I need them to just remain white if there is not information in the cell. And if the cell contains a 0 the first condition says to color that cell in. Is it possible to distinguish between a 0 and an empty cell Edit: Automod has reminded me to provide some information Libre office version 6.3.3.2, windows 10, ODS file Also you can ignore condition 8, I didnt mean to include that. That condition was me trying to solve the problem. Share Report Save level 1 1 year ago edited 1 year ago An empty cell is equal to - whups I mean - 1 Share Report Save level 2 Original Poster 1 year ago Please tell me Im doing something wrong. Libreoffice Writer Remove Blank Lines Free And OpenShare Report Save Continue this thread View Entire Discussion (11 Comments) More posts from the libreoffice community Continue browsing in rlibreoffice rlibreoffice LibreOffice is a free and open source office suite used by millions of people around the world. Its a successor project to OpenOffice(.org) with regular releases, extra features, and improved compatibility (.docx export). Libreoffice Writer Remove Blank Lines Free Software ProductivityHere you can ask questions to other users, and talk about LibreOffice, The Documentation Foundation and the Free Software productivity community 6.3k Members 42 Online Created Sep 29, 2010 Join Top posts january 11th 2020 Top posts of january, 2020 Top posts 2020 help Reddit App Reddit coins Reddit premium Reddit gifts about careers press advertise blog Terms Content policy Privacy policy Mod policy Reddit Inc 2021.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |