I opened an excel spreadsheet, and at times my entries will suddenly change to red or be automatically “completed” with information I don’t want entered. For example, I have made 10 entries in a col titled “arrival time” and the next cell auto completes with a phone number I have NEVER entered. Intermittently a cell’s font color will turn to red, but when I click on font color ‘black’ is already highlighted; I have unchecked 'automatically detect high contrast mode…", and I am not using high contrast mode and it does not help.
Please jacquemeihoffe, what is your LibreOffice version, Operating System, excel file version?, can you attach or give a link to a sample file?
VERSION 4.0.2.2, windows 8 (on a new toshiba satellite laptop, and I dislike windows 8 very much); I would have replied sooner but I didn’t know someone had added a comment. How can I attach the spreadsheet file? It’s an excel 97 file.
re: “answer” posted by ROSt52: formatting my hard drive and installing another operating system is irrelevant to the problem. This should have been added as a “comment”, not an "answer. Perhaps next time you could help with one of the three issues in this thread? To reiterate: how does one turn off automatic font color, how does one turn off auto-complete, how does one upload an excel file (the last I find is not possible from searching the FAQ area).
holy crap. 5 hours and i get one putz who wants me to attach a file which isn’t possible, and another who posts an “answer” that’s a fucking useless irrelevant suggestion. boy am i glad i have a copy of microsoft office to install.
@jacquemeihoffe -…and I dislike windows 8 very much… I can understand that. I got new PC just before W8 was introduced. I created an image of my HD just to keep my W7 installation for something I hope never will happen; formated my HD and installed the ancient XP, and I am very happy! Fast and stable running PC. Currently with LibO 3.6.6
Consider if this would be a solution for you as well.
The feature you are fighting against is called conditional formatting. See Formatting → Conditional formatting. If this bit of knowledge doesn’t get you going, just ask again or comment here.
A not so useful wiki page: Conditional Formatting - LibreOffice Help