https://bugs.documentfoundation.org/show_bug.cgi?id=130722
--- Comment #4 from Mike Kaganski <[email protected]> --- (In reply to Mike Kaganski from comment #3) > So it *looks like* an interoperability issue. It would be nice to check what > Excel does in this case. Note that trying to re-create the calculation using Excel 2016's What-If analysis (one-variable data table [1]) on the data from attachment 157933, moving F4:F5 to F10:F11, I4 to H10, clearing H11:H13, selecting G10:H13, running the Excel's "Data Table", and selecting G11 as "Column input cell", I get "Input cell reference not valid" error from Excel. Indeed, I might do it all wrong; a sample spreadsheet doing this from Excel would hopefully clarify. [1] https://support.microsoft.com/en-us/office/calculate-multiple-results-by-using-a-data-table-e95e2487-6ca6-4413-ad12-77542a5ea50b -- You are receiving this mail because: You are the assignee for the bug.
