[Libreoffice-bugs] [Bug 59417] Data entry form does not support formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=59417 Charles Taylor changed: What|Removed |Added Version|3.6.1.2 release |6.4.6.2 release --- Comment #18 from Charles Taylor --- when using sum ie. =sum(A1:A23)/14 when i close the file i loose the answer to the sum -- 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 59417] Data entry form does not support formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=59417 Gerhard Weydt changed: What|Removed |Added CC||gerhard.we...@t-online.de --- Comment #17 from Gerhard Weydt --- Testing with Version: 6.0.4.2 (x64) Build-ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; Gebietsschema: de-DE (de_DE); Calc: CL I found that formulas are not overwritten. I hesitate to change the satus, though, that should be done after more testing. -- 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 59417] Data entry form does not support formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=59417 --- Comment #16 from guyles...@yahoo.fr --- Hi I am not really happy in helping you highlighting problems. As per all this, I am quite not sure I will not report any issues so far. Nb: i was a informatic engineer in 1970 and i have difficuties to understand why it is so long and so complicated. As you can see below, this is the message i answerred today referring to your message "[Bug 59417] Data entry form does not support formulas" dated 2018-03-17. There is no mention in this message that i cannot respond to the message but via this web. So the below message was returned "Sorry, we were unable to deliver your message to the following address.: 554: 5.7.1 : Recipient address rejected: You replied to a Bugzilla notification email. However email replies are not added to bug reports. Please visit https://bugs.documentfoundation.org/ instead to add a follow-up." So basically i loosed my time again. Nevertheless i went to your site but my password was outdated , so again spending time for a new password. original answer of today - Hello Thomas Answer & suggestion. Sorry but this bug has been submitted in january 2013 … more than 5 years ! … and i still do not know if you solved it or not as not found within all links neither tested : in between i buyed a MS Office365 monthly licence (5 users) Please notice that the way your message appeared (see below), - I first tought your message was a bulk - I hesitated to simply delete it - because uncomprehensive immediately. Suggestion : please show first or last message from the requester, within the text of the message in order that he can refer to immediately . I am very reluctant to click on links which are not evidently secured because there are so much dangerous bulk messages. Anyway, thanks for your answer and sorry for my poor english . Hope you understand what i wrote. Best regards -- 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 59417] Data entry form does not support formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=59417 Thomas Lendo changed: What|Removed |Added Blocks||116461 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116461 [Bug 116461] [META] Data Entry Form bugs and enhancements -- 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 59417] Data entry form does not support formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=59417 --- Comment #15 from burnu...@gmail.com --- Bug is still present. No changes in bug behavior. Testsystem: LO 5.2.3.3 on Windows Vista -- 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 59417] Data entry form does not support formulas
https://bugs.documentfoundation.org/show_bug.cgi?id=59417 --- Comment #14 from burnu...@gmail.com --- Still open bug confirmed in https://bugs.documentfoundation.org/show_bug.cgi?id=96707 -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 --- Comment #13 from Alex Thurgood --- (In reply to comment #11) > Alex, the original code comes from one of Novell's former team mates, and > was developed as an internal feature not an extension. > > The developer you referenced above is probably the author of the extension > version of the same functionality. But these two are two different code set. Hi Kohei, Oh, ok, thanks for correcting me on this. Good to know :-) Alex -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 Kohei Yoshida changed: What|Removed |Added Severity|minor |enhancement --- Comment #12 from Kohei Yoshida --- I take this as an enhancement request. -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 --- Comment #11 from Kohei Yoshida --- Alex, the original code comes from one of Novell's former team mates, and was developed as an internal feature not an extension. The developer you referenced above is probably the author of the extension version of the same functionality. But these two are two different code set. -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 Alex Thurgood changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #10 from Alex Thurgood --- Confirming, as it seems that the original developer, who built this code as an extension, before integration into LO source tree, is already aware of the issue : http://listarchives.libreoffice.org/fr/users/msg08281.html Alex -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 --- Comment #9 from guyles...@yahoo.fr --- Hi I am currently in a foreign country, returning home by tuesday and then i can send you a sample excel file and the way i use it. Thanks in advance for your comprehension. I presume ipla...@yahoo.co.uk = Alex Thurgood from who i saw a very good translation french-to-english. Comment # 1 on bug 59417 from Alex Thurgood Thank you for your report, but for future reference, please note that in order to get any attention, bug reports should be filed in English. Translation of the original post follows : Description of the problem : Using an Excel file as a datasource loaded into LO Calc. I generally work on this file in Excel using the "Data Forms" tool, which enables me to enter data as a table without overwriting cells containing formulae. In Calc, the equivalent function is totally incorrect and thus unusable. What is the solution? Thanks in advance Best regards Guy LESIRE http://www.myspace.com/guylesire/photos before printing this email, think about the environment Le 19 janv. 2013 à 15:46, bugzilla-dae...@freedesktop.org a écrit : Alex Thurgood changed bug 59417 WhatRemovedAdded StatusNEWNEEDINFO Comment # 8 on bug 59417 from Alex Thurgood We need a sample Excel file that uses the Data/Forms functionality, setting to NEEDINFO. Alex You are receiving this mail because: You reported the bug. -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 Alex Thurgood changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #8 from Alex Thurgood --- We need a sample Excel file that uses the Data/Forms functionality, setting to NEEDINFO. Alex -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 Alex Thurgood changed: What|Removed |Added CC||kohei.yosh...@suse.de, ||markus.mohrhard@googlemail. ||com --- Comment #7 from Alex Thurgood --- Adding Kohei, Markus to CC. @Kohie, Markus : Data corruption by overwriting "pseudo" or "real" write protected cells in an Excel sheet through the Form/Data dialog when imported into Calc. As I'm not a Windows user, and have never used this function in Calc I can go no further - care to take a look ? Alex -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 --- Comment #6 from Urmas --- I haven't found duplicates. -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 --- Comment #5 from Alex Thurgood --- (In reply to comment #4) > In Excel, the fields with formulas are read-only when using Data Form. When > new records are added, the formulas from the first row are copied to a new > record. > > Libreoffice Data Form can corrupt the formulas in calculated fields. Thanks for the extra info Urmas, you don't happen to know if this has already been reported by any chance ? Alex -- 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 59417] Data entry form does not support formulas
https://bugs.freedesktop.org/show_bug.cgi?id=59417 Urmas changed: What|Removed |Added Summary|FORMCONTROLS: formulaire|Data entry form does not ||support formulas -- 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