Hi, The problem I have is with cells formatted as date type. If I specify the input language (French(France)) it doesn't stay after I close the spreadsheet. And next time I open it it has switched to english, so a date is taken as english american format 12/31/2014 instead of 31/12/2014 (French format) even if the format is specified as 31/12/2014. I bet the problem comes when I want to specify a language for the sheet. In the Spelling menu I have to clic twice on the language I want to be set. And as soon as I live the box I have to reset it as the one I want : French(France). Hope it helps. Keep up the good job Alex
Hi Alex, what LibreOffice version are you using? what is your OS language and what are the linguistic settings under Tools > Options > Languages Setting > Language? Do you have those patterns D/M/Y;D/M;D.M.Y;D-M-Y in the Date acceptance patterns field? Setting as Needinfo - Sophie
Created attachment 109400 [details] Language window
Created attachment 109401 [details] Date Formats
Hi Sophie, Thanks for the reply. Version: 4.3.3.2 Build ID: 430m0(Build:2) OS is Linux Ubuntu 14.10 The info for languages is in the Language.jpg file. The info for date format at cell level is in the DateFormat.jpg file. I think I understand my mistake because I didn't set the language French in the options. The thing is I may use and French and English and mix them up in documents. And it seems that LibreOffice doesn't allow to specify specific language for some cells, only for the entire spreadsheet though. If I specify some language in the cell format windows it seems it doesn't remember my choice. Am I clear in my description/analysis ? Best regards, Alex
(In reply to Alex from comment #4) > Hi Sophie, > > Thanks for the reply. > > Version: 4.3.3.2 > Build ID: 430m0(Build:2) > > OS is Linux Ubuntu 14.10 > > The info for languages is in the Language.jpg file. Here the setting is English, so separators, currencies, dates, etc... will be English format > The info for date format at cell level is in the DateFormat.jpg file. Here also the setting is English. > > I think I understand my mistake because I didn't set the language French in > the options. yes :) > The thing is I may use and French and English and mix them up in documents. you should be careful here with Calc because it impacts not only the display but calculations too. > And it seems that LibreOffice doesn't allow to specify specific language for > some cells, only for the entire spreadsheet though. If I specify some > language in the cell format windows it seems it doesn't remember my choice. > Am I clear in my description/analysis ? Yes. However, and I didn't test it with your settings, you should add the following formats to the Date acceptance patterns field: D/M/Y;D/M;D.M.Y;D-M-Y, that should allow you to handle French date formats and may be enough. If you need further help, please come on the users@ list or the Ask forum (info are available here: http://www.libreoffice.org/get-help/community-support/ I'm closing this report, as it's a mismatch in your settings and not a bug. Kind regards - Sophie