https://bugs.documentfoundation.org/show_bug.cgi?id=145048
--- Comment #1 from hardcoder <[email protected]> --- Created attachment 175627 --> https://bugs.documentfoundation.org/attachment.cgi?id=175627&action=edit Example workbooks using CELL() and their screenshots, zip-packed. I'm uploading three .xlsx workbooks using the CELL function, in a .zip file: 2021-10-10-Highlighter.xlsx: A simple sheet that has a table with some numbers. You can highlight all occurrences of a number in the table by selecting a cell with the number and hitting F9 (recalculate). This was achieved through conditional formatting. 2020-03-09-Cell-controls.xlsx: A sheet showcasing a few in-cell controls: a boolean switcher, a vowel switcher and a spin button. They are reusable within a sheet, thanks to defined names. 2021-03-31-Game03.xlsx: A sokoban-like game (that's right, a spreadsheet game without macros). There are more complex games that can also be made, but I read that I should "make the [attached] document as minimal as possible." I can upload another game on request. These last two workbooks also depend on iterative calculation; as Calc's iteration is replete with bugs, it will certainly take some time before they work well in LibreOffice. But they work fine in Excel for Windows and WPS Office Free. I also included .png screenshots of each workbook. -- You are receiving this mail because: You are the assignee for the bug.
