> Am 05.09.2020 um 14:54 schrieb Ian Piper <ian.pi...@tellura.co.uk>: > > Is there a method that allows me to load the value (that is, “Forces”) rather > than the formula?
What if you use ReadString on that cell? > I have a second question about using XL. At present the way that I am reading > my sheet is by row and then by column within a row, and I am creating an > array for each row, which I then write to the listbox using AddRow. Is there > a more direct way to write the value from an Excel cell (say I14) to a cell > in the listbox. The Xojo user guide is not clear on whether this is possible. You can always put a value in the cell: list.addrow "Hello" list.cell(list.lastindex, 1) = "1234" list.cell(list.lastindex, 2) = "2345" list.cell(list.lastindex, 3) = "3456" Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/ _______________________________________________ mbsplugins@monkeybreadsoftware.info mailing list %(list_address)s https://ml-cgn08.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
