| Summary: | CALC: UI: MACRO: array function not working from macro | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | b. <newbie-02> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | xiscofauli |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | testsheet where only one array function is evaluated and only on load | ||
|
Description
b.
2020-01-09 02:28:19 UTC
Created attachment 157025 [details]
testsheet where only one array function is evaluated and only on load
testsheet where only one array function is evaluated and only on load
Hi b, to me, it seems the same as bug 43003. What's the reason you created another bug? Could you please explain the difference between them ? @xisco: - yes, mostly the same, - new aspect: second instance of array not calculated, - refresh for bug hunting session, - shorter more concise sample, - after 8 years and two 'refresh-refocussing-requests' i doubt commenting there will help, - see: https://www.youtube.com/watch?v=31xA9p3pYE4&feature=youtu.be&t=1029 - sorry, german - orienting statement: 'i once met the guy who manages the IE bugs ... he said: "there are so many bugs coming in, we don't get to work on them, we just manage them" '. reg. b. (In reply to b. from comment #3) > @xisco: > > - yes, mostly the same, > - new aspect: second instance of array not calculated, > - refresh for bug hunting session, > - shorter more concise sample, > - after 8 years and two 'refresh-refocussing-requests' i doubt commenting > there will help, > - see: https://www.youtube.com/watch?v=31xA9p3pYE4&feature=youtu.be&t=1029 - > sorry, german - orienting statement: 'i once met the guy who manages the IE > bugs ... he said: "there are so many bugs coming in, we don't get to work on > them, we just manage them" '. > > reg. > > b. Well, I agree with you, but reporting the same bugs again and again doesn't help either. Besides, the summary is talking about macros, while the steps doesn't mention anything about macros *** This bug has been marked as a duplicate of bug 43003 *** @xisco: "'Well, I agree with you, but reporting the same bugs again and again doesn't help either." well i agree with you, neither way produces / produced any progress, "Besides, the summary is talking about macros, while the steps doesn't mention anything about macros" the "macro(s)" are / is the function 'incdinc' - a macro 'function' - used as an array formula in CD4 and CD6, to handle 'old' bugs i suggest the following: if a thread become too long, then after 12 month without progress a developer or someone with skills writes a concise summary of the bug and the info collected, and that is posted two times, once as last comment for the original bug, that closed as 'old', and posted a second time together with the relevant attachements and a reference to the old bug as the start of a new thread. "*** This bug has been marked as a duplicate of bug 43003 ***" what doesn't help either, if i'm remembering right @Eike wrote somewhere that macro functions can't be evaluated in all situations, and that the expectations from 'recalculates all cells in a sheet / file' in the help / manual are too high ('manual is misleading'), could be an approach to check whether that applies to this situation, and if: correct help and manual. reg. b. |