{"id":445,"date":"2010-02-18T18:48:20","date_gmt":"2010-02-18T16:48:20","guid":{"rendered":"http:\/\/blog.louic.nl\/?p=445"},"modified":"2014-11-12T21:13:41","modified_gmt":"2014-11-12T19:13:41","slug":"turn-off-auto-complete-in-openoffice-calc","status":"publish","type":"post","link":"https:\/\/blog.louic.nl\/?p=445","title":{"rendered":"Turn off auto complete in libreoffice or openoffice calc and writer"},"content":{"rendered":"<p>Assuming you already found the Tools -> Autocorrect options (which is exactly where you'd expect it to be), that still leaves the (very annoying) autocomplete function enabled. To turn it off in calc, you need to disable:<\/p>\n<blockquote><p>Tools -> Cell Contents -> AutoInput<\/p><\/blockquote>\n<p>This will turn it off until you turn it back on. I found it thanks to <del datetime=\"2013-07-15T11:16:07+00:00\"><a href=\"http:\/\/nowacki.org\/blog\/2004\/05\/disable_autocomplete_in_openoffice.html\">this weblog<\/a><\/del> (update: link is dead).<\/p>\n<p>Unfortunately, when editing a table in Writer, some auto-correct options still remain: numbers are automatically \"corrected\", +1 and 1.0 for example change into \"1\". This can be changed by<\/p>\n<blockquote><p>setting the \"Number format\" (in right-click menu) of all cells to \"Text\".<\/p><\/blockquote>\n<p>You can probably change the default table style to fix this forever, but I have not tried yet.<\/p>\n<p>(Why do the bloody programmers always think they know better what I want to do than me? If I type two capital letters that is because I want them. If it was a mistake I can correct it myself. Stop forcing this unwanted \"automatic\" guessing: <del datetime=\"2014-11-12T19:15:30+00:00\">90%<\/del> 99% of the time the guess is wrong!)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Assuming you already found the Tools -> Autocorrect options (which is exactly where you'd expect it to be), that still leaves the (very annoying) autocomplete function enabled. To turn it off in calc, you need to disable: Tools -> Cell &hellip; <a href=\"https:\/\/blog.louic.nl\/?p=445\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[44,41],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.louic.nl\/index.php?rest_route=\/wp\/v2\/posts\/445"}],"collection":[{"href":"https:\/\/blog.louic.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.louic.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.louic.nl\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.louic.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=445"}],"version-history":[{"count":28,"href":"https:\/\/blog.louic.nl\/index.php?rest_route=\/wp\/v2\/posts\/445\/revisions"}],"predecessor-version":[{"id":449,"href":"https:\/\/blog.louic.nl\/index.php?rest_route=\/wp\/v2\/posts\/445\/revisions\/449"}],"wp:attachment":[{"href":"https:\/\/blog.louic.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.louic.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.louic.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}