질문하기

FAL's profile - activity

2018-07-02 11:16:57 +0200 받은 배지  정리의 달인
2017-04-09 18:09:24 +0200 코멘트달린 답변 LO 5.3.1Base report conditional formatting

Perfect! Thank you!

2017-04-09 18:05:05 +0200 으뜸 답변으로 표시됨 LO 5.3.1Base report conditional formatting

I created a simple report from an Invoices table, where each row shows one invoice with its data. There is also a currency formatted field showing the balance, and I would like that field to be written in three different colors based on its value: black and bold if it is more than one cent, red if it's less than -1 cent, or italic and grey if between -0.01 and 0.01. I used conditional formatting on the Balance field, and at first (I only gave one condition) my report worked as expected. Later I added the other two conditions, and suddenly the conditional formatting stopped working: all the rows showed the Balance in the default Currency formatting instead of the one I chose. I tried putting back one single condition in the Conditional Formatting for the Balance field, but it took no effect. Can somebody help me? Francesco esempio.odb

2017-04-06 17:12:24 +0200 받은 배지  주목할 만한 질문 (source)
2017-04-06 08:47:11 +0200 코멘트달린 답변 LO 5.3.1Base report conditional formatting

Ok. Added esempio.odb.

2017-04-06 08:45:59 +0200 받은 배지  편집자 (source)
2017-04-06 08:45:59 +0200 질문을 편집했습니다 LO 5.3.1Base report conditional formatting

LO 5.3.1Base report conditional formatting I created a simple report from an Invoices table, where each row shows one in

2017-04-06 08:42:35 +0200 코멘트달린 답변 LO 5.3.1Base report conditional formatting

Ciao! I don't know if I can add an attachment... I'll try to.

2017-04-05 08:02:52 +0200 받은 배지  인기있는 질문 (source)
2017-04-04 16:10:57 +0200 질문하였습니다 LO 5.3.1Base report conditional formatting

LO 5.3.1Base report conditional formatting I created a simple report from an Invoices table, where each row shows one in

2017-03-21 00:58:17 +0200 질문에 답변하였습니다 Python macro to show calculated totals

Standing on librebel's shoulders. I could finally solve my problem. Actually, it's simpler than you told me, librebel!

def set_FormControl_Value( oForm, strControlname, myvalue ):
"""
    Sets the Value of the specified control. If the control is formatted,
    then it will take care of the formatting
    You only have to give it a myvalue of the right type.
    For example, if strControlname is a Currency field, 
    myvalue has to be a Float. 
"""
if oForm:
    oCtrlModel = oForm.getByName( strControlname  )
    if oCtrlModel:
        oCtrlModel.Value = myvalue
2017-03-20 17:11:57 +0200 코멘트달린 답변 Python macro to show calculated totals

I tried your suggested command, but as I feared, FindColumn() only works with table - backed fields. It seems it doesn't know of fields lacking a database-resident value...

2017-03-20 17:11:57 +0200 받은 배지  논객
2017-03-20 10:45:45 +0200 받은 배지  유명한 질문 (source)
2017-03-20 02:07:46 +0200 코멘트달린 답변 Python macro to show calculated totals

I'm too sleepy to try it now, it's two o' clock and I'll have to get up at six. But as soon as possible I'll try these new functions. But where can I find a complete documentation? Where did you find all available functions and commands? I did not find a language and module reference.

2017-03-20 01:54:05 +0200 코멘트달린 답변 Python macro to show calculated totals

I saw your comment only now! THANK YOU! but the fields I want to change have no value in the table, I try to calculate them from the table fields. Basically, I try to display a total due and a balance based on some fields in the current record. And I want to update them while the user edits the record.

2017-03-20 01:49:20 +0200 코멘트달린 답변 Python macro to show calculated totals

I could see that your set_FormControl_TextValue() macro does actually change the text of the given field, but if you try to read the same field afterwards with your get_FormControl_Value(), you find it zeroed. Why?

2017-03-20 01:48:58 +0200 받은 배지  개근상
2017-03-19 20:28:23 +0200 코멘트달린 답변 Python macro to show calculated totals

No way... can't find out how to change my question, too. :-)

2017-03-19 20:24:32 +0200 코멘트달린 답변 Python macro to show calculated totals

Can't add code in a comment... too long. Trying to revise my question.

2017-03-19 20:20:56 +0200 코멘트달린 답변 Python macro to show calculated totals

I managed to change the fields I needed to change with your macro, librebel. But I feel there's still something wrong: those fields are formatted with Currency, but they only receive the text I give them. Is there a way to set their value with a Float, and to have them display it with the proper currency? Worse, while one of those fields correctly displays the value I give it, the other one gets a very different value from the one I give... I don't know why. Code follows.

2017-03-19 02:29:40 +0200 코멘트달린 답변 Python macro to show calculated totals

Again, Thank you!

2017-03-18 12:00:28 +0200 코멘트달린 답변 LibreOffice 5.1.0.3 not starting after fresh install on Windows XP

Thank you very much! It worked. I uninstalled, then removed the suggested folder, then installed 5.1.1.3. PERFECT!

2017-03-18 12:00:23 +0200 으뜸 답변으로 표시됨 LibreOffice 5.1.0.3 not starting after fresh install on Windows XP

I use currently LibreOffice 5.0.3 without any problems. I tried installing LibreOffice 5.1, but it did not start. No error message, just the hourglass for a few seconds, then even that ceases. Repeated about 5 times.

So I uninstalled LibO 5.0.3, restarted my PC and installed 5.1 again. Same exact behaviour.

Is 5.1 compatible with Windows XP? (my Windows is fully updated, with Service Pack 3 and every released update installed) Should I stay with 5.0.3 forever?

Thank you in advance Francesco

2017-03-17 20:59:17 +0200 코멘트달린 답변 Python macro to show calculated totals

THANK YOU, librebel! This was exactly what needed. I did not know where to look... Could you please direct me to some documentation about thisComponent.getDrawPage().getForms() to find more useful info by myself?

2017-03-17 20:53:55 +0200 으뜸 답변으로 표시됨 Python macro to show calculated totals

I'm writing a Python macro to read fields in currently shown Base form, and use them to calculate value for another field in the same form. I don't know how to access those fields. Could anybody help me?

2017-03-17 20:53:55 +0200 받은 배지  학자 (source)
2017-03-17 20:53:46 +0200 받은 배지  조력자 (source)
2017-03-16 15:02:32 +0200 받은 배지  주목할 만한 질문 (source)