Description: This has happened since I switched to Libre a couple years ago. Still happens in 7.3.0.3 (x64). My Win 10 is set to Dark theme, but changing back makes no difference. Windows Magnifier 'Invert colors' makes no difference. Yes, I've changed some Libre color settings, but none of the changes affected this view. In other Calc views, selecting a cell or its text usually makes some difference - not here. Selecting a column or row does invert its whole area, but no text ever appears. The import process always imports everything, usually correctly... But if it guesses wrong there is no hope of adjusting it! Steps to Reproduce: 1.Open any .csv file 2.The Import preview pops up 3.No visible data Actual Results: No visible data Expected Results: Preview of data dividers Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.3.0.3 (x64) / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded But lots of previous versions were affected... Sorry, I'm not into installing some unknown app that messes with my drivers and wants $10 per month. No idea about OpenGL.
Created attachment 178231 [details] Typical view, same in any mode or display setting
Please attach test .csv file. Thank you.
Or test disabling Skia, Menu/Tools/LibreOffice/View
Created attachment 178235 [details] Random csv file that shows the problem.
I found Tools -> Options -> View -> Graphics -> Use Skia and disabled it. Restarted, verified it is disabled. No difference. Tried a bunch of random csv files, all looked the same in the Import dialog. Toggling to Width mode doesn't change the view. Tried the Attached csv in Arch Linux, preview worked properly. But I haven't made any dark mode changes there - it just picked up the system dark theme. See screenshot. Headers of selected columns are colored very differently from data or unselected headers there. In Windows, entire columns and their headers are either black or white. My actual spreadsheet data now looks great in Windows with my dark settings. Somehow this csv Import doesn't match real data... Is there some dev mode that lets one see which format choice is controlling which visual item?
Created attachment 178236 [details] 'Random csv file' in Arch Linux looks good.
You can test with fresh user profile: menu Help > Restart i safe mode
@raal Somehow that safe mode shows actual data! Maybe I'd already changed color settings before I first tried csv import... My vision is so bad it is miserable to work with white backgrounds or a low-contrast dark mode. I spent hours of searching and experimenting to get the actual spreadsheet content into a usable pure white text on pure black dark mode. This csv import dialog is the only place where that doesn't seem to be working. I'd rather keep 99+% of my work comfortable than sacrifice that for a dialog I rarely use. I'll ask again... Is there some tool that can tell you which color settings affect some particular detail of the display? Apparently the csv import dialog is set up quite differently from actual sheet content. Having to randomly experiment with dozens of mysterious color options affecting different parts of the program differently is no fun... I'm thankful Libre lets me turn my content high-contrast dark, I couldn't find any way to do that in Excel. Wish I could get the rest of the app as nicely dark as it is in Linux, but dark content is more important.
More compulsive searching... https://bugs.documentfoundation.org/show_bug.cgi?id=142172 V Stuart Foote 2021-05-15 17:55:49 UTC ... No reason we can't devise themes suitable for multiple os/DE--to optionally bypass os/DE themeing. But what is holding LO back continues to be that not all components of the UI are exposed for control in the Application Colors panel and its .xcu configurations. Both facets--toggle to bypass os/DE "system" theme, completing a framework for UI application colors--will need dev attention. I guess that's what I'm encountering - some parts of the csv import dialog are affected by my mode choices, but not all of them respond like the sheet content does. I imagine this is a hassle for everyone involved!
Sorry, one more... I went back to Safe Mode and made a single change: Tools -> Options -> LibreOffice -> Application Colors -> Color Scheme -> Libre Office Dark The csv preview became _almost_ invisible - see screenshot. Apparently the tweaks that get me maximum contrast in spreadsheet content eliminate that tiny bit of default contrast in the import dialog. Personally I'd call the untweaked screenshot version "invisible" for practical use. Maybe you could tweak the official dark theme? Or probably better, tweak the csv import dialog to use colors like the actual sheet content does? That code must already exist...
Created attachment 178248 [details] Safe Mode plus official Dark Theme - _almost_ invisible
Contrast is still a problem with the new Dark Theme on Libre Office 7.4 in the Importwindow.
Created attachment 181936 [details] LO 7.4 Calc Import Window Bad Contrast in Dark Theme
Still happening in 7.3.2.2. And a major frustration because of what is probably a separate bug: I regularly import data in the same format to the same sheet. All the tries appear to show that they remember the import settings correctly, but about half the tries somehow move the division at column 19 to column 18 in the actual import result - even though the preview shows 19. I have to move the preview divider to col.20, do an import which divides at col.20, then move it back to col.19 which then works. This would be much easier if I could see the data, but it is so predictable I can now do it blind.
Created attachment 182954 [details] Text Import dialog (dark mode + dark color scheme) I confirm this with the latest master LO 7.5+ Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: d1707bc31261d16893c1f5240c803d283e293ec1 CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL threaded The problem is that the dark theme (via Tools - Options - Application Colors) change the document background color, which affects the CSV import dialog. See attached image of the dialog using kf5 (Linux). I'm setting this to NEW.
Created attachment 182955 [details] Text Import dialog (patched) I created a patch that tries to fix this problem. See attached image of how it looks now.
Here's the patch available for review in Gerrit.
Here's the patch available for review in Gerrit. https://gerrit.libreoffice.org/c/core/+/141177
Rafael Lima committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/de387e611df7668fb86a409255de6d49eeef3e90 tdf#147386 Fix text color in CSV import dialog (dark mode) It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Sorry @Rafael, for me it's fine for the data, but not for the column title. Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ddb8a1a282aae74c1cee3a5e1f446abd0c00b116 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en- Calc: CL threaded
(In reply to m.a.riosv from comment #20) > Sorry @Rafael, for me it's fine for the data, but not for the column title. Can you try again on an empty profile? Or at least reset the UI modifications? If the problem persists, please attach a screenshot so I can try to figure out what the problem is.
Created attachment 183523 [details] Sample file with screenshots With Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 3c0be5564afe1b9cc843a49aba88b72af74c43ab CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: threaded The title of the selected column, it's difficult to read it.
(In reply to m.a.riosv from comment #22) > The title of the selected column, it's difficult to read it. So you think the header color should use Black when selected?