From the WP_Query docs: 'any' - retrieves any status except those from post types with 'exclude_from_search' set to true. (There is a typo there, they actually mean post statuses instead of post types.) This means statuses auto-draft and trash are excluded.