Description: Name of sheets have the same limitation in ODS than with other formats Steps to Reproduce: 1. Double click on sheet tab 2. Hit Help button 3. Hit "Renaming Sheets" link at the end Actual Results: Help page: https://help.libreoffice.org/Calc/Renaming_Sheets Two things which are not exact: - limitation of name is the same whatever file format chosen - max number of sheet is higher than 256 Expected Results: Replace: "Sheet names can contain almost any character. Some naming restrictions apply when you want to save the spreadsheet to Microsoft Excel format. When saving to Microsoft Excel format, the following characters are not allowed in sheet names:" With: "Sheet names can contain almost any character. Some naming restrictions apply, the following characters are not allowed in sheet names:" Increase max number of sheets to 1024 according to: https://opengrok.libreoffice.org/xref/core/sc/inc/address.hxx#80 Reproducible: Always User Profile Reset: No Additional Info: Help page: https://opengrok.libreoffice.org/xref/help/source/text/scalc/guide/rename_table.xhp#53 User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0
Same problem with Windows 10
Hi Laurent, Jean-Luc, Reproduced with LO 6.0.1.1 (x64) Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6 Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; Locale : fr-FR (fr_FR); Calc: CL and previous versions. Sheets Max number was given in LO 3.5 release notes (10000) https://wiki.documentfoundation.org/ReleaseNotes/3.5 but can be hardly reached and remains theoretical.
Laurent BP committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=90671d8531b28cebf6129402932320a437cf4544 tdf#115831 Renaming of sheet
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=5339d3c91fb81ea593a96c5602b767d68aba623f tdf#115831 Review of rename sheet help page