Issue 65346

Summary: Forms: read/write access to imported data
Product: Base Reporter: gimpy <netman1>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description gimpy 2006-05-13 19:37:52 UTC
Forms created from linked data, such as a spreadsheet, are read-only in Base. 
Would like a way to enter new data in forms to these linked sources.  Going one
step further, and a better solution, would be a true data import function in
Base where a new database, independant of the source file, can be created with
imported data from a spreadsheet or a tab-delimited text file.
Comment 1 Mechtilde 2006-05-14 09:11:05 UTC
Hi,

>Forms created from linked data, such as a spreadsheet, are read-only in Base.
There is no primary key and so you can't edit.

>Would like a way to enter new data in forms to these linked sources.  Going one
>step further, and a better solution, would be a true data import function in
>Base where a new database, independant of the source file, can be created with
>imported data from a spreadsheet or a tab-delimited text file.

You can copy the table from the Base file to a new file based on the internal
HSQL. If you add a primary key you can enter new datas.

Set it to feature 
Comment 2 christoph.lukasiak 2006-06-12 11:33:41 UTC
thx mechtilde

reopen issue to send as feature enhancement to the requirements team
Comment 3 christoph.lukasiak 2006-06-12 11:40:03 UTC
the 'read only state' constraint of some data sources is annoying (specially if
it is a native calc spreadsheet) - even if you can 'workaround' this like
mechtilde has written, this should not be the final solution, so hopefully this
will be improved, but the decision belongs to the requirements team

thx
Comment 4 Mechtilde 2008-01-07 22:24:05 UTC
I think we can set it to New