Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-28 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Bruce, > On form Form_Filter, is it possible to define the List Box using > General - List Entries and Data - ValuelList No problem to define it separately. But I would only use this kind of entries if I would knew all entries, which ever should

Re: [libreoffice-users] Save button

2016-08-28 Thread M Henri Day
2016-08-28 4:42 GMT+02:00 jorge : > Hi: > > As I understand, it depends of the Theme and Icon Style that you have > installed in your LO: > > Menu-> Tools-> Options-> View-> User Interface-> Theme and Icon Style > > For example: > > In my Ubuntu 16.04 LTS->LibreOffice 5.1.4.2-> Style Oxygen-> Icon

[libreoffice-users] Re: example convenience of calc

2016-08-28 Thread Denis Navas Vega
El 2016-08-26 a las 05:03, message escribió: Readers, Useful to be able to type in the command line: libreoffice --calc --nologo https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/450279/Progress_8_2015_opt_in_schools_final_list.ods Then the spreadsheet appears directly

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-28 Thread Bruce Hohl
On form Form_Filter, is it possible to define the List Box using General - List Entries and Data - ValuelList (without using the separate table Filter and query Query_Filter)? The Base Handbook has brief comments on the List Entries & ValueList but only defining those items does not produce a work

Re: [libreoffice-users] highlight color won't change

2016-08-28 Thread V Stuart Foote
When you save what format? If to .docx it won't survive round-trip filtering. It should be correct if you save to ODF Text .odt format. Which is it? From: PegM4 Sent: Thursday, August 25, 2016 6:53 AM To: users@global.libreoffice.org Subject: [libreoffic

Re: [libreoffice-users] Trying to make a macro

2016-08-28 Thread jorge
Hi Felipe: I interested in make a macro like this because I've had in past jobs to work with files generated with other system in .txt format. They are a lot and I had to open and got their data to paste on a spreadsheat for working with them. Those files generated each month with the same structu

Re: [libreoffice-users] Trying to make a macro

2016-08-28 Thread Robert Funnell
On Sun, 28 Aug 2016, Felipe T. Dorado wrote: On Sun, 28 Aug 2016 14:08:53 +0200, Felipe escribió: FTD> I notice that you call your .csv file a "sheet" and I think it is not FTD> a sheet, yet, but a text file. I found the "Import" sheet option in the menus. I found it in "Insertar" > "Hoja de

Re: [libreoffice-users] Trying to make a macro

2016-08-28 Thread Felipe T. Dorado
Hola Jorge : ) On Sun, 28 Aug 2016 14:08:53 +0200, Felipe escribió: FTD> I notice that you call your .csv file a "sheet" and I think it is not FTD> a sheet, yet, but a text file. I found the "Import" sheet option in the menus. I found it in "Insertar" > "Hoja de archivo", which in English shou

Re: [libreoffice-users] Trying to make a macro

2016-08-28 Thread Felipe T. Dorado
Hola jorge : ) On Sat, 27 Aug 2016 05:47:09 +, jorge escribió: J> Good evening: ' Afternoon. I'm also interested in importing .txt files into a spreadsheet adequately. J> I try to make a macro in Calc to insert a sheet from a file in .txt J> format or .csv using the LO process: Record macr

Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

2016-08-28 Thread Robert Großkopf
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Alanon, could be you are looking for something like this: http://robert.familiegrosskopf.de/download/Filter_Database.odb One table "Table" with the content you will list, one other table called "Filter" with only one row. A query lists the conten