Bug Hunting Session
Bug 59417 - Data entry form does not support formulas
Summary: Data entry form does not support formulas
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 59394 (view as bug list)
Depends on:
Blocks: Calc-DataForm
  Show dependency treegraph
 
Reported: 2013-01-15 12:51 UTC by guylesire
Modified: 2018-08-15 16:48 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description guylesire 2013-01-15 12:51:41 UTC
Problem description: 
la base est un fichier excel ouvert avec Libre Office/Classeur.
Ce fichier je travaille dessus en excel avec la fonction "données/formulaire" qui me permet d'entrer des données sous forme de tableau sans écraser les cellules contenant des formules.
Dans "classeur" la fonction identique est totalement incorrecte et donc inutilisable.
Solution?
Merci par avance

Steps to reproduce:
1. ....
2. ....
3. ....

Current behavior:

Expected behavior:

              
Operating System: Mac OS X
Version: 3.6.1.2 release
Comment 1 Alex Thurgood 2013-01-15 14:04:37 UTC
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
Comment 2 Alex Thurgood 2013-01-15 14:09:55 UTC
Guy, désolé de le dire, mais ce rapport est incompréhensible. "Inutilisable" et "incorrect" ne veut rien dire sans un exemple concret ou description détaillée sur la manière de reproduire le problème rencontré.

Guy, my apologies for saying this, but your report is incomprehensible. "Unusable" and "incorrect" don't mean anything without a concrete example or a detailed description of how to reproduce the problem you are experiencing.

This will be marked as INVALID if more detailed information is not provided, preferably with an example Excel file, on how to reproduce, step-by-step, the problem you are experiencing. 


Alex
Comment 3 Alex Thurgood 2013-01-15 14:15:54 UTC
*** Bug 59394 has been marked as a duplicate of this bug. ***
Comment 4 Urmas 2013-01-15 14:24:28 UTC
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.
Comment 5 Alex Thurgood 2013-01-15 14:36:29 UTC
(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
Comment 6 Urmas 2013-01-16 03:19:08 UTC
I haven't found duplicates.
Comment 7 Alex Thurgood 2013-01-19 14:44:50 UTC
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
Comment 8 Alex Thurgood 2013-01-19 14:46:20 UTC
We need a sample Excel file that uses the Data/Forms functionality, setting to NEEDINFO.


Alex
Comment 9 guylesire 2013-01-20 11:38:22 UTC
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 iplaw67@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-daemon@freedesktop.org a écrit :

Alex Thurgood changed bug 59417 
What	Removed	Added
Status	NEW	NEEDINFO

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.
Comment 10 Alex Thurgood 2013-01-22 14:29:15 UTC
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
Comment 11 Kohei Yoshida 2013-01-23 15:04:15 UTC
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.
Comment 12 Kohei Yoshida 2013-01-23 15:05:25 UTC
I take this as an enhancement request.
Comment 13 Alex Thurgood 2013-01-23 15:07:53 UTC
(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
Comment 14 burnuser 2015-12-27 20:25:30 UTC
Still open bug confirmed in https://bugs.documentfoundation.org/show_bug.cgi?id=96707
Comment 15 burnuser 2017-01-08 10:02:13 UTC
Bug is still present. No changes in bug behavior.
Testsystem:
LO 5.2.3.3 on Windows Vista
Comment 16 guylesire 2018-03-19 12:07:08 UTC
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.<bugzilla-daemon@bugs.documentfoundation.org>:
554: 5.7.1 <bugzilla-daemon@bugs.documentfoundation.org>: 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
Comment 17 Gerhard Weydt 2018-08-15 16:48:56 UTC
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.