Description: While opening an MS Excel file, with more than 1024 columns (AMJ), via the API, a warning is shown (maximum columns exceeded warning, SCWARN_IMPORT_COLUMN_OVERFLOW). LibreOffice has been opened in "hidden" mode through the API, the warning is the only visible part of LibreOffice and has to be dismissed/acknowledged by user interaction (pressing the only button "OK"). I've attached a test document created in MS Excel with the value "Test" written in cell 1:AMK (1:1025). I also attached an MWE using the API's C++ binding. From what I've found so far, this seems to be an error related to not calling ScExternalRefManager::ApiGuard::ApiGuard. The warning is only shown if rDoc.IsUserInteractionEnabled() returns true in sc/source/filter/oox/excelfilter.cxx. ScExternalRefManager::ApiGuard::ApiGuard sets the mbUserInteractionEnabled variable to false in the SCDocument. My current knowledge of the LibreOffice source code is a bit short, therefore I can't provide a fix right now. I will try to provide one, if you consider the displaying of the warning (while in API mode) an unwanted behaviour. I've tested this on Windows 10 using LibreOffice 6.3.3.2, 6.4.7.2 and 7.0.3.1. All of them are affected. I also suspect this affects all operating systems and likely earlier versions too. Steps to Reproduce: 1. Start an instance of LibreOffice via the API. 2. Open an Excel file with more than 1024 columns calling com::sun::star::frame::XDesktop2::loadComponentFromUrl(). Open the document in hidden mode. Actual Results: The warning "maximum columns exceeded" is shown before com::sun::star::frame::XDesktop2::loadComponentFromUrl() returns. This warning is the only visible part of LibreOffice. Expected Results: The warning shouldn't be shown, since LibreOffice has been opened via the API and no user interaction is to be expected. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.3.1 (x64) Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 16; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded
Created attachment 168219 [details] MS EXcel file with more than 1024 columns
Created attachment 168220 [details] MWE for demonstrating the behaviour
I think, today, when we already have support for more than 1024 columns in current 7.4 master builds , this report can be closed as WFM Tobias, could you please test current development build by link https://dev-builds.libreoffice.org/daily/master/current.html
LibreOffice 7.4 solves this problem. We no longer get a warning about exceeding columns. This ticket can be closed.