질문하기

Goyo's profile - activity

2018-02-03 17:04:46 +0200 받은 배지  조력자 (source)
2017-01-21 20:36:57 +0200 받은 배지  족집게 도사 (source)
2017-01-21 20:36:57 +0200 받은 배지  선생님 (source)
2015-07-07 18:55:33 +0200 받은 배지  주목할 만한 질문 (source)
2015-04-08 15:30:35 +0200 받은 배지  편집자 (source)
2015-04-08 15:29:28 +0200 질문에 답변하였습니다 Copying from a table control in a form (Base) to a spreadsheet (calc) does not work

Just figured it out. Drag the upper-left square and drop it into calc. It won't copy exactly the table control but the underlying data sorce so you may have to rearrange the columns.

2015-04-08 14:53:49 +0200 질문에 댓글을 달았습니다 Copying from a table control in a form (Base) to a spreadsheet (calc) does not work

I think the question is: How do I copy the contents of a table control into a spreadsheet / text file /whatever? There seem to be no obvious way of doing it yet (LO 4.4)

I would edit the question but I don't know how to do it.

2014-10-15 20:56:07 +0200 받은 배지  인기있는 질문 (source)
2014-09-30 12:31:37 +0200 질문에 답변하였습니다 Form change data with substitution from referenced table

I guess you want to use only one form (using "person" as data source) and then a list box for city_id in that form.

2014-09-26 19:38:23 +0200 질문에 답변하였습니다 How Do I Achieve A "Vlookup" In A Base Query?

Try this:

SELECT *, "Contact_FName" || ' ' || "Contact_LName" AS "Contact_Username" FROM "Table 1"
2014-09-26 13:42:20 +0200 질문하였습니다 Can I make base form fields follow locale settings?

If I change the locale settings in LO, decimal and thousand separators change accordingly. In Calc this happens even in cells with a custom format.

But in base form fields, as soon as I change anything in the format (like the number of decimal places) the locale settings selected in LO do not affect the decimal and thousand separators anymore.

I wonder if there is a way to make form fields work like calc cells so they use the LO locale separators even if custom format codes are used. Maybe I've just hit a bug?

Context: I have a database document (.odb) connecting to an ODBC database. Copies of the .odb file are distributed to uses at several countries and they would like lo see numbers in form fieldas formatted according to their locale settings, as it happens with spreadsheets.