Created attachment 125407 [details] xlsx with dotted sheet If sheet in xlsx has dotted name in russian, pointer to it not converted This problem only in xlsx, not in xls Example attached
Seems the sheet name with dots needs to be between single quotes, It' mandatory where it contains other characters than alphanumeric or underscore. Help link: https://help.libreoffice.org/Calc/Renaming_Sheets Resolved as not a bug, if you are not agree, please reopen it.
Please attention: this is .docx document!!! This is problem is compatibility problem. You also can open this document in Excel and save as .xls In this case LibreOffice open it correctly.
Confirmed. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: ab0189433c1593c3c3ccf6a947aa7ba84e806d91 CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on May 28th 2016
Please attach ods file format which could be next exported into .xlsx
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170131
With attached sample works for me with: Version: 5.2.5.1 (x64) Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: es-ES (es_ES); Calc: group
At the moment I checked this error in 5.3.0.3 It is still present in 5.3.0.3 I think that this error is very simple and stable to repeat. I do not know what additional information do you need?
(In reply to Andrew from comment #7) > I do not know what additional information do you need? Please read your email notifications.. Bartosz asked for an ODS on 2016-08-04, comment 4
Created attachment 130808 [details] dotted sheet - reversed (ods original)
Created attachment 130809 [details] dotted sheet - reversed (xlsx exported)
(In reply to Buovjaga from comment #8) > (In reply to Andrew from comment #7) > > I do not know what additional information do you need? > > Please read your email notifications.. Bartosz asked for an ODS on > 2016-08-04, comment 4 I do not understand why, but the attached file. there original .ods file and exported to .xlsx I pay attention that there is no problem with export. the problem is with the import.
(In reply to Andrew from comment #11) > I pay attention that there is no problem with export. the problem is with > the import. What is the problem with import? I don't see any problem. Everything is in correct order, not reversed.
(In reply to Buovjaga from comment #12) > (In reply to Andrew from comment #11) > > I pay attention that there is no problem with export. the problem is with > > the import. > > What is the problem with import? I don't see any problem. Everything is in > correct order, not reversed. Please open first file (https://bugs.documentfoundation.org/attachment.cgi?id=125407) and recalculate. Also you can see incorrect reference format.
(In reply to Andrew from comment #13) > Please open first file > (https://bugs.documentfoundation.org/attachment.cgi?id=125407) and > recalculate. Also you can see incorrect reference format. Sure, but I can't see the problem with the new file. You never explained, where attachment 125407 [details] came from. Did it come from Microsoft Excel? Version..?
(In reply to Buovjaga from comment #14) > (In reply to Andrew from comment #13) > > Please open first file > > (https://bugs.documentfoundation.org/attachment.cgi?id=125407) and > > recalculate. Also you can see incorrect reference format. > > Sure, but I can't see the problem with the new file. > > You never explained, where attachment 125407 [details] came from. Did it > come from Microsoft Excel? Version..? This is come from MS Excel 2013. But this problem present in Excel 2016 also.
Sorry my mistake testing.
6.0.0.0.beta2 No changes. :-(
Somebody fixes the bug?
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Reference is still imported as: =имя.листа!a7 vs =$'sheet.name'.A7 The former becomes a #NAME? error after Ctrl-Shift-F9, the latter works correctly. Version: 7.0.0.0.alpha1 (x86) Build ID: 6a03b2a54143a9bc0c6d4c7f1... CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés: Skia/Raster; VCL: win; Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded
Still repro: Reference is still imported as: =имя.листа!a7 vs =$'sheet.name'.A7 The former becomes a #NAME? error after Ctrl-Shift-F9, the latter works correctly. Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: cb2827f5f65324f309fa0e3c30d0b19ad237410e CPU threads: 16; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Created attachment 183130 [details] xlsx with error
Still repro: Reference is still imported as: =имя.листа!a7 vs =$'sheet.name'.A7 The former becomes a #NAME? error after Ctrl-Shift-F9, the latter works correctly. Created attachment 1183130 [details] When opened through Libreoffice Calc incorrect data and error after Ctrl-Shift-F9 Version: 7.4.2.3 / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded
Dear Andrew, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug