https://bugs.documentfoundation.org/show_bug.cgi?id=153425
--- Comment #11 from ady <[email protected]> --- FWIW, I can reproduce this without Excel at all. Also, there must be something very specific in order to trigger this issue, because I'm getting mixed results. I was trying to reproduce this in LO 7.4.5, without starting from an imported file. I tried several different minor variations in the procedure: * Having a column label (or not). * Using AutoFilter (or not). * Using one unique value (either true or false, not both). * Dragging the mouse in order to fill the data, all in one step (i.e. one dragging movement), or instead making 2 movements (i.e. dragging once up to row 99, release the mouse, dragging again up to row 210). * Filling more (or less) rows. * Using TRUE() and FALSE(), or TRUE/FALSE, or combining these. I could go on with additional minor differences. Observations: Using AutoFilter, the first time I get many different values within the AutoFilter list itself (many FALSE, TRUE, 0 and 1s). I mean that AutoFilter itself lists these values repeated times (with its own checkbox, etc.). After I PageDown, PageUp, the list in AutoFilter now shows each value 1 time (i.e. up to 4 different items at most, depending on the values being displayed on the cells). To be clear, I didn't even select a specific value; the resulting list is not filtered, no action was performed other than scroll down/up, and yet the AutoFilter list is different. Since I haven't modified the values, why AutoFilter would recognize them differently first, but as equivalent values the second time? I kept trying different minor adjustments to the procedure. Using "Save" or using "Save As" (I'm not sure anymore), I ended up with 2 xlsx files with the same original content, but one file opens up showing TRUE/FALSE only, whereas the other displays TRUE/FALSE/0/1. In some cases (of all my attempts), I only closed the file, whereas in others I also closed LO entirely. Sometimes the 0/1 values are "in the middle" of the data rage; sometimes they are only seen in the bottom half of the rows. To be clear, I never introduced numbers in these attempts. Now I have 2 xlsx files created with LO 7.4.5, with the exact same original content, showing 2 different things, with 2 different size weights: * 6KB (incorrect, with 0/1 too) vs. * 17KB (with TRUE/FALSE only). I see problems with AutoFilter, and with how the values are displayed in the respective cells (and in which range). The only problem is that I cannot identify a step-by-step procedure that I could describe in order to reproduce exactly what I did so to obtain these files, or why I see the 0/1 values in different ranges (considering that I am opening the same exact file). Although I'm not able to describe a clear procedure ATM, I am sharing this experience here, just in case someone else sees some similar behavior. -- You are receiving this mail because: You are the assignee for the bug.
