DataForm

On oOo 4.1.2 and Windows 10: functions as promised.
Thank you.

Version 3 of databaserangemanager is more efficient and easier to use

Databaserangemanager works well
1 - if the fields are correctly formatted.
2 - if the first record has no empty fields
3 - if the second record comprises at least one value
Read the help pages DRM included in the help page of AOO

Dataform is obsolete. AOO progress has been made since version 2.1
Dataform not know treat all data formats
See and compare DatabaseRangeManager

This extension appears to be broken. After much fiddling, we can get it to show an input form for 26 fields using the column headers (if *any* cell is empty for selecting "data range" it does not produce the input form.)
However, it systematically overwrites the first row of the existing spreadsheet.
We have tried to define the "data range" by selecting the last row of the spreadsheet, and it reports: "Table not found. Select a range or single cell in the table area and try again", then comes up with a "Basic runtime error. An exception occurred. Type com.sun.star.lang.IndexoutofboundsException."
Conclusion - it looked promising but does not work (at least for us.)

I downloaded this just now, and installed it in Open Office 3.2.1
for operating system Windows XP Pro.

I installed it - the agreement appeared, etc. and the extension manager
showed it installed.

The item appears in the Data menu.

I clicked on the first cell of my table that had data ( i.e. the second row,
first column), then chose Data/dataform.
Nothing appeared. I tried several other cells - nothing.

Any suggestions? This is a really handy feature which I have used
in MS Excel many times.

I wish also you might add some navigation features as in the MS version..

Thanks,!

Salve,
First thanks for the great extension. Works very well on OOo3.2.1. One quick request. Would it be possible to allow the size of the Form window to be adjusted (made bigger). People with longer cells would like to be able to read the entire contents of a cell without scrolling. This is only possible if the Form window can be made wider.
Ciao,
Jonathan

I encountered a problem with incorrect date values. Will stop the macro and display the source code...
I found a simple solution, show an error message and delete the contents of cell

Function salvaRecord as Boolean
.....

change these lines

  datetime1 = DateValue(txtCampo.Text)
  cella.Value = datetime1

with these other

If IsDate(txtCampo.Text) = False Then
  MsgBox("Valore Data Errato")
  cella.setString("")
Else
  datetime1 = DateValue(txtCampo.Text)
  cella.Value = datetime1
EndIf


I am using the form with Open Office version 3.2 and have not had any problems. I really like it but wish it would pick up more columns that could be seen. Maybe if the format were a couple of columns wide.

Given the date of the release, when I saw other comments of install difficulties I wasn't sure if it worked for 3.1. It works OK. I installed it today on a WinXP system.

Be apprised it does not create a modifiable "Forms" data entry screen where you can move things around the screen. It simply presents a pop-up to generate a new row for an existing table, or edit a row of a table. So it is not nearly the "Forms" functionality that is provided in the Base package, or even the advertised Excel functionality. You won't be building a "GUI" with this.

I downloaded the extension storing the file (DataForm-0.9.0.oxt) on my ubuntu 8.04, OpenOffice 3.1.0 desktop. The installation states to "Double-click on the extension file and follow the instructions." When I double click on the file I get a box pop up that informs me "There is no application installed for this file type".

How can I proceed? Thanks!!

Hi
I have been waiting for this extension for some time now and am very pleased with your great effort.

Thank you very much.

Texhead

Trying to install this plug-in, I get the following error :

Configuration Parser: a
com.sun.star.xml.sax.SAXParseException occured while
parsing : - {Parser Error : [ line 33]: invalid tokenerror }.

I am on kubuntu 8.04 running openoffice 2.4.1

Hi, could you add support for record navigation through keyboard (PgUp, PgDown, Up, Down, Home, End)? I think this will improve usability for your great extension.

Thank you.

Cool extension. Just wondering if you might consider an improvement where the user could select from a drop-down one of the existing column entries -- so one could either type in a new entry or just select one from a list of those already previous used in the table.

Hi.

I find errors in translation to spanish. I correct the files. Can you recieve the files?

Eduardo Moreno
TOKONHU de México

Hi Cobo

At my day job we're talking about ways to make order-taking easier for our staff, so we've been discussing databases, etc., but these get complex really fast. Then I saw your extension and tried it and it's ideal! It would be really easy to create a spreadsheet with a heading for each field, pop up a form and the staff could enter all the info very easily. So here's my question....

Would it be possible to make the form pop up automatically when opening a file? If so, could it be done so that it only opens with specific files rather than all files? I'm envisioning putting a link on a staff computer pointing to a centrally stored 'order form' spreadsheet file out on our network. Staff could click the link and the form pops up ready to fill out, then they add their info and save the file. The person filling the order could then open the file from their computer and process the order.

I'll totally understand if this is too big a pain to implement.

Hello,
I use some keys to naviguate into form dialogbox
Tab = go to next field
Shift + Tab = go to previous field
Enter = validate the record
If I press Enter in the last field, the record is validate but I don't go to a new one.
I press Enter again and it work!

Hi !
I upload this estension on Open Office .
How i use it ?
Thank you !
Carpe Diem !