If there is an actual solution to permanently disable this feature that I am unaware of, please for the love of all that is holy let me know. How has MS allowed this war crime against data to continue for so long? Are they sadists or just incompetent? I want it eviscerated and erased from humanity’s collective memory. I don’t even want the option to manually enable this feature.
#Openoffice turn off auto numbering code#
Seriously, I want to permanently disable it by metaphorically ripping it root and stem from my system with no traces left except a smoldering crater where the code responsible for this was. Words cannot describe my absolute hatred for this feature. There are so many scenarios where this feature screws me that it is impossible to predict. Sometimes I don't notice the changes because they don't alert you in any way and then months later it comes back to haunt me as a confusing web of deceit that I must untangle after someone finds data that makes no sense. Sometimes I need to use an existing document and it makes these changes immediately before there is a chance to use any workarounds (and of course you can't undo them). I shouldn't need some combination of workarounds like "just populate every cell with an apostrophe" and/or "just make sure every cell is not the default cell format" and/or "just tinker with the data import features until it works" just to get Excel to stop ******* my **** up. Because of it, I have to use OpenOffice LibreOffice Calc for some operations because Excel is simply not viable (which sucks because OpenOffice LibreOffice Calc can be slow and buggy, but at least it doesn't try to actively sabotage me). I am capable of entering and formatting my own data without the equivalent of some meth-smoking babysitter with the IQ of a particularly dumb rock deciding that it knows better than me.
This is a feature that irreversibly changes user data with no way to revert changes, neither asks the user beforehand or alerts them afterward, and has no option to permanently disable this ************* feature that I have NEVER, not ONCE, wanted. To say this is absolutely ridiculous is an understatement. Because obviously what I typed was a mistake and I was actually referring to the 64th day of January (/s) Here are some recent examples of this feature telling me and my data to go **** ourselves: My coworkers and I refer to this feature as “Excel’s automatic data-f*****-upper”.
#Openoffice turn off auto numbering software#
I'm just gonna rant because I don't think there are any solutions: Excel automatically reformatting data is the worst intentional feature I have ever encountered in any software ever, and that is not hyperbole.
They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.
NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 kommentar(er)
