how to enable auto-save in spreadsheets similar to Excel
Please don’t assume, that users of LibreOffice know about functionality of other software products when addressing a question to them. Please specify, which functionality you require and I’m pretty sure you’ll get an answer, whether this can be achieved with LibreOffice - or not. In that sense: Please explain “similar” in detail.