Created attachment 102774 [details] Boolean values created on Excel 2007 An XLSX file with well formatted boolean values is showed as numbers 1 or 0 rather than special words TRUE or FALSE and boolean formatting, and any consecutive values (sibling rows) are not showed except when the value is different from previous row. Example (extra padding added for readability): one column and several rows with values: [ TRUE , TRUE , FALSE , FALSE , FALSE , FALSE , TRUE , TRUE , TRUE , TRUE ] are showed by LibreOffice as: [ 1 , , 0 , , , , 1 , , , ] and clicking on every cell, they shows values: [ =TRUE(), =TRUE(), =FALSE(), =FALSE(), =FALSE(), =FALSE(), =TRUE(), =TRUE(), =TRUE(), =TRUE() ] In the given attachments, click on every cell, specially the empty one, to see that there is a value but nothing showed on cells when previous showed value is the same. I upload several attachments as examples: - File created from scratch with Excel 2007 - File created from by a third party app that exports a datatable as XLSX, basic type formatting only; I changed the column name with Excel2007, but using the source files gives the same results and the same internal XML (I check it the unzipped content before and after the column name). - File created with LibreOffice 4.2.5.2 and saved as ODS, everything fine in this case even reopening the file. - File created with LibreOffice 4.2.5.2 and saved as XLSX; when you close and open the file with LibreOffice, the problem appear.
Created attachment 102775 [details] Boolean values created on Excel compatible app
Created attachment 102776 [details] Boolean values created on LibreOffice 4.2.5.2 as ODS
Created attachment 102777 [details] Boolean values created on LibreOffice 4.2.5.2 exported as XLSX
(In reply to comment #0) > one column and several rows with values: > [ TRUE , TRUE , FALSE , FALSE , FALSE , FALSE , TRUE , TRUE > , TRUE , TRUE ] Confirmed with: 4.1.6.2 (Format Cells: BooleanValue|TRUE) 4.0.6.2 (Format Cells: Number|Standard) > are showed by LibreOffice as: > [ 1 , , 0 , , , , 1 , > , , ] Confirmed with: LO 4.3.0.3, 4.2.6.1, 4.2.0.0.beta1 (Format Cells: Number|Standard) Set Version to 4.2.0.0.beta1: the first version which wrong viewed cells appear > and clicking on every cell, they shows values: > [ =TRUE(), =TRUE(), =FALSE(), =FALSE(), =FALSE(), =FALSE(), =TRUE(), > =TRUE(), =TRUE(), =TRUE() ] Those shown in all versions tested. I don't set regression since I don't know what is the correct format setting. > - File created with LibreOffice 4.2.5.2 and saved as XLSX; when you close > and open the file with LibreOffice, the problem appear. Filesave problem with xlsx : Bug 68117 Tested on Ubuntu 12.04 32bit
** 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 on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) 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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16
I think this bug is highly related to: https://bugs.documentfoundation.org/show_bug.cgi?id=70565 Could you please describe (step by step), how are you creating .xlsx file via MS Excel? It will dramatically simplify testing process.
Hi, Please, next time you assign a bug to yourself, remember to change the status and the assignee. Regards
Hi, Sorry to don't answer to previous requests of re-testing. As seen at the related bug #86456, the problem of 'hidden values' at consecutive rows with same value seems solved at version 5.4.0.3 (x64) Windows 7 SP1. From about me dialog: Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c CPU threads: 4; SO: Windows 6.1; UI render: default; Locale: es-ES (es_ES); Calc: group. I tested both the files I originally attached and the two files attached at #86456, and just like eisa01 commented there 'shows 0/1 with =FALSE()/TRUE(), so this may just be a presentation issue now?' Current fix is a good step forward, though. And yes, the bug #86456 and this older seems the same. But about the bug https://bugs.documentfoundation.org/show_bug.cgi?id=70565 , don't know exactly what has fixed, but it seems a formatting bug still exist here. Steps to reproduce: - At Excel 2007 - New document, at different rows type values 'TRUE' and 'FALSE'. - Save as XLSX - Open In LibreOffice - It displays 1, 0 - Note: the formula bar at LibreOffice says =TRUE() , =FALSE() while at Excel still says TRUE , FALSE. - Additionally: if at Excel we type '=TRUE' and '=FALSE' (adding the equals sign), it displays the same both at Excel and LibreOffice, but LibreOffice shows at the formula bar =1 , =0 on this case.
** 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
Hi, I can confirm this still happens as of today latest version in same way as last update at Comment #8. Versión: 6.1.0.3 (x64) Id. de compilación: efb621ed25068d70781dc026f7e9c5187a4decd1 Subprocs. CPU: 4; SO: Windows 10.0; Repres. IU: predet.; Configuración regional: es-ES (es_ES); Calc: CL Changelog: https://gerrit.libreoffice.org/gitweb?p=core.git&a=log&h=efb621ed25068d70781dc026f7e9c5187a4decd1 In addition, I just verified that the values showed at the formula bar are the same in the XLSX file created with Excel 2007 (first attachment) and LibreOffice (fourth attachment), but the formatting is different: - For the one created with Excel: Libreoffice displays "1, 1, 0, 0, 0..." - For the one created with LO: Libreoffice displays "TRUE, TRUE, TRUE, FALSE, FALSE,..." I reviewed the cell formatting options, and they have: - For the one created with Excel: Standard number formatting - For the one created with LO: User defined formatting, with format "TRUE";"TRUE";"FALSE" It seems weird that no file have chosen the 'boolean formatting' option. If I apply that manually to both file, the display is the correct one, identical on both. What I cannot confirm now is if the XLSX format, or that Excel 2007 version, supports the 'boolean bormatting', in case that happens and is the issue (and the reason why LO chose to save the file with a custom formatting). If that's the case, maybe have changed in recent format/program versions, someone knows?
*** Bug 120664 has been marked as a duplicate of this bug. ***
Dear IagoSRL, 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
Created attachment 178142 [details] The example file in Excel 2013 and Calc master Still a problem in: Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: bb7873cebd191143e2c0bcf944c8c777be5439dc CPU threads: 14; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: threaded The cell formatting of these is General in Calc, but switching to "Boolean Value" on import would result in the same look. This would not (neither is the current display) affecting the usability of such cells e.g. as logical condition in an IF() function.
This should now be solved in 7.4 with the fix for bug 122098.
Created attachment 178592 [details] The first example file in current master It is indeed fixed in: Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: aafd4c8431aa511511375ff39f87a7f8bde726e0 CPU threads: 14; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: threaded