so i used libreoffice calc the other day and had to deal with formatting. i have dd/mm/yy dates but it thought they're mm/dd/yy dates, and you can't actually change it - it always assumes the initial formatting is true. if you change it in the settings it'll just swap the date and month. i hate wysiwyg software.




