Hi,
when using calc and using the formula Lookup over tabs the Libre Calc keeps crashing straight away without being able to use it.
I use this formula x100 in my sheets as it is very usable/workable formula.
My only work around at the moment is I copy an other Lookup formula from the sheet and change that formula.
Any Idea how to fix it?
Try if you can use “it” in safe mode. If yes, backup and then reset your user-profile.
.
Otherwise: No idea, not enough data.
.
A crash would be a reason to report a bug. But for a useful report, you’d need to tell exactly what you do and share your file, so one can try to reproduce this on other computers. If it only happens to you, it is quite difficult to fix…
Does that happen with every document? Here is one of mine:
https://ask.libreoffice.org/uploads/short-url/4H0AVs6l8qxkdQtpETjk1fktwCM.ods
Bug has been reported multiple times.
In safe mode it still crashed so no help there.
For the rest it is a financial data sheet where I lookup data from a protected tab (for security reasons).
I have been developing this sheet over de last 7 years and it is pretty heavy in formulas.
The crash occurs only when I start to chose a range of data in a column with data not the resulting value (ie the second value in the formula).
Can you give us a link/number ?
?? Sorry, can’t follow…