Created attachment 185736 [details] form this file is working only with microsoft 365, not even online version i want to use it with linux and libre office
Sorry, what it is not working?
i cant see what is inside cells in Opatření specifického cíle: Aktivita (je-li relevantní): Podaktivita (je-li relevantní): there is menu, which i can choose, but i cant, because i cant see it
I see, c10:c14 are blank with Calc, and after save an reopening, validation for those cells disappears. What happen with web version of excel. Also, after show comments on B10:B11 they stay behind validation cells, after save and reopening there are visible. Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-USCalc: CL threaded and Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 687b950702c49c90cff9a43655ea97a0343799a0 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo
This file has not validation, but form controls - changing meta. Several issues can be seen here. First is that default values (selected in Excel) are empty. Let's focus this report on this part. Second is that selecting something from the first dropdown breaks the second dropdowns possible values, that is bug 100374 Third is that the comment, when shown is overlapped by the form control. This is split out to bug 164347.
Created attachment 198150 [details] The example file in Excel and Calc with last selected value The example file is attachment 198148 [details] from bug 164347