Fai la tua domanda

FAL's profile - attività

2019-12-07 13:01:54 +0200 received badge  Domande famose (source)
2018-07-02 11:16:57 +0200 received badge  Tassonomista
2017-04-09 18:09:24 +0200 ha commentato una risposta LO 5.3.1Base report conditional formatting

Perfect! Thank you!

2017-04-09 18:05:05 +0200 ha accettato una risposta 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 received badge  Domanda notevole (source)
2017-04-06 08:47:11 +0200 ha commentato una risposta LO 5.3.1Base report conditional formatting

Ok. Added esempio.odb.

2017-04-06 08:45:59 +0200 ha modificato una domanda 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:45:59 +0200 received badge  Revisore (source)
2017-04-06 08:42:35 +0200 ha commentato una risposta 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 received badge  Domanda gettonata (source)
2017-04-04 16:10:57 +0200 ha posto una domanda 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 ha risposto a una domanda 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 received badge  Commentatore
2017-03-20 17:11:57 +0200 ha commentato una risposta 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 10:45:45 +0200 received badge  Domande famose (source)
2017-03-20 02:07:46 +0200 ha commentato una risposta 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 ha commentato una risposta 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 ha commentato una risposta 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 received badge  Entusiasta
2017-03-19 20:28:23 +0200 ha commentato una risposta 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 ha commentato una risposta 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 ha commentato una risposta 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 ha commentato una risposta Python macro to show calculated totals

Again, Thank you!

2017-03-18 12:00:28 +0200 ha commentato una risposta 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 ha accettato una risposta 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 ha commentato una risposta 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 ha accettato una risposta 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 received badge  Studioso (source)
2017-03-17 20:53:46 +0200 received badge  Sostenitore (source)