[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 Eike Rathke changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WONTFIX --- Comment #22 from Eike Rathke --- Array formulas can't be created by text import that way. Period. Not a bug. Won't fix. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g Blocks||109236 Summary|Inconsistent treatment of |Inconsistent treatment of |array formulas if imported, |array formulas if imported, |inserted or entered as text |inserted or entered as text |using the curly brackets. |using the curly brackets Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109236 [Bug 109236] [META] CSV import bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #21 from QA Administrators --- Dear rstill74, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #20 from Wolfgang Jäger --- Created attachment 155322 --> https://bugs.documentfoundation.org/attachment.cgi?id=155322=edit Example with directly entered text looking like array formula I don't know if the original reporter (rstill74) continues to observe this bug, but: I tested with V 6.3.3.1rc and the described behaviour was unchanged. Hoping to get things even more clear I attach a very simple example .ods made with the mentioned version where the text contents looking like a array formulae were directly entered using the keyboard. The effects are the same as with content read from a csv file. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #19 from QA Administrators --- Dear rstill74, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #18 from Wolfgang Jäger --- Tested with V 6.3.3.1rc Behavioiur unchanged. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #17 from QA Administrators --- Dear rstill74, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #16 from Wolfgang Jäger --- Tested again with V6.1.3.1RC. Behaviour unchanged. (Please also read the final paragraph thoroughly.) I already included a suggestion with my demonstrations to solve the issue by creating an alternative way to enter a formula for array-evaluation. See file bug_tdf93973InconsistencyConfirm_1ReloadedFromCSV.ods contained in the .zip attached to Comment #10. This second way was to simply enclose the formula in curly brackets as it is displayed anyway after being recognised. Concerning the present case of importing formulae from a csv this might be accomplished by finding the output range for the top-left occurrence of the formula with a query for the range of its adjacent repetitions. I'm inerested in your comments on the question if filing that suggestion as a feature request (enhancement "bug") might be the better way to get the old issue resolved. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #15 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #14 from Wolfgang Jäger--- Tested again with V5.4.2. on Win 10: Behaviour still as described in the original report. Emphasizing the inconsistencies: -1a- Non-array formulas are recognized as formulas on import. -1b- Array formulas are not. They are dysfunctional and shown as texts. -1c- 'Numbers' format of the respective cells remains 'General'. -2a- Going edit mode (F2, not the wizard) the mode is "formula-editing": Emphasizing references, no curly brackets. -2b- Escaping the edit: Formula is text again - with curley brackets. Still 'General' numbers format. -2c- The wizard doesn't regognize a formula at all. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #13 from Wolfgang Jäger--- The link to late en.libreofficeforum . org in the original post is broken due to the shutdown of that forum (sigh). There is a (not searcheble) archive where you still find the thread under discussion: http://www.imaccanici.org/en.libreofficeforum.org/node/11459 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #12 from QA Administrators--- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 Buovjagachanged: What|Removed |Added Status|UNCONFIRMED |NEW Version|unspecified |3.6.5.2 release Ever confirmed|0 |1 --- Comment #11 from Buovjaga --- Thanks, Wolfgang. Let's set to NEW. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 Wolfgang Jägerchanged: What|Removed |Added Attachment #127920|The archive mentioned in my |The archive mentioned in my description|Comment#8; Demonstration of |Comment#10; Demonstration |the claims |of the claims -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 Wolfgang Jägerchanged: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #10 from Wolfgang Jäger--- (In reply to Xisco Faulí from comment #8) > Dear Bug Submitter, > > This bug has been in NEEDINFO status with no change for at least > 6 months. ... I am not the original reporter here. Nonetheless I think I understood the problem and can confirm it. A new description might get wordy and not much more clear than it was already tried. Thus I made a demo consisting of 4 files (of which only 3 are relavant. One is an simple ods containing ordinary formulae and an array formula as well. It was saved while the option 'Display' > 'Formulae' was switched on. >From this comes the second file to whitch the relevant sheet of the first one was written using 'Save As...'. Now a new (untitled) ods document was created and the mentioned csv was used to insert a sheet there. Later it was save to "bug_tdf93973InconsistencyConfirm_1ReloadedFromCSV.ods" The mentioned files are packed into the attached zip archive. Start opening the last mentioned one and read the few lines of text there. You may open the other files then as needed. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #9 from Wolfgang Jäger--- Created attachment 127920 --> https://bugs.documentfoundation.org/attachment.cgi?id=127920=edit The archive mentioned in my Comment#8; Demonstration of the claims -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #8 from Xisco Faulí--- Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20161010 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 Buovjagachanged: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||todven...@suomi24.fi Ever confirmed|0 |1 --- Comment #7 from Buovjaga --- rstill: regarding comment 6: I am setting to NEEDINFO. Change back to UNCONFIRMED, if you are not happy with the solution. Change to RESOLVED WORKSFORME, if you are happy. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 m.a.riosvchanged: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #6 from m.a.riosv --- Created attachment 123749 --> https://bugs.documentfoundation.org/attachment.cgi?id=123749=edit Sample CSV with SUMPRODUCT() instead brackets. I think not always but in many situations you can involve the formula with the SUMPRODCUT() function, it is an array function so you don't need the brackets. And open the csv with it works fine for me. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 rstil...@gmail.com changed: What|Removed |Added Summary|problems importing csv file |Inconsistent treatment of |containing array formula|array formulas if imported, ||inserted or entered as text ||using the curly brackets. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #4 from rstil...@gmail.com --- title changed as suggested -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 93973] Inconsistent treatment of array formulas if imported, inserted or entered as text using the curly brackets.
https://bugs.documentfoundation.org/show_bug.cgi?id=93973 --- Comment #5 from rstil...@gmail.com --- to Jean-Baptiste Faure: I wanted to apologize if my response to your message came across as offensive. It was not intended that way. It was merely surprise. I admit that I am forcing the venerable .csv format to do things it wasn't really meant to do, but it seems to me that many other parts of LibreOffice and it's documentation implicitly acknowledge that it's not that rare. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs