Base how to create a 3 level form

[Rickblender2017]

let say that I have an open writer or Calc document
them I open up an internet site if I find something interesting on a web page on Edge or IE11
I copy some text or numbers or the URL

and try to paste it to the open libre office document
it is refusing the pass it even with Ctr-V

so this might be a bug or is there a work around to make it work ?

one note
it does work if web page is already opened up and if libreoffice if off and then i open up a new document
but as soon as I change web page it does not work anymore
so have to close all libre office documents and re start opening document
this is very annoying for the least!

thanks for any feedback
have a nice day

[Ratslinger]

Hello,

You are likely not getting any response to this because it is utterly confusing.

• Opening title refers to Base and a Form

• Tag refers to Calc

• Initial question describes a problem copying to Writer or Calc

• You posted an answer which is not an answer. Answers are to actually answer the original question.

• The not-an-answer is actually another question dealing with some macro.

This is a question and answer site. If you have multiple questions, please post as individual questions. It is always helpful if you post the specific LO version you are using and your OS. For Base the database used.

Please either correct this post or delete and re-post appropriately.

Thank You.

[Rickblender2017]

Need help to modify a Calc Macro for 3D spline
interpolation algo

this is use for the efficiency and Power factor of electrial motors
AC 3 Phases

all my motors data are on one specific page

i have like 20 Motor size - from 1 HP to 400 HP

i tried to change the address in the macro call and
tried with indirect address or else ect.
and it does not work

here is the Function call in a cell

Macro call

= cubspline(1,W18*100, $‘Spline HP’.B194:B207,$‘Spline HP’.$C194:$C207)

Description of parameters

W18 * 100
this is the motor loading in %

$‘Spline HP’.B194:B207,$‘Spline HP’.$C194:$C207

this is the address for the motor Spec

so each time i change the motor Size i have to manually
provide the data addresses
which is very tedious

now this is working fine but not flexible at all!

I would like to find a way to modify the macro parameters
to make it easier to use

Example

= cubspline(1, HP , Loading , EFF )

HP
this would be the Motor size in HP

Loading
this is same as before = % Motor Loading

EFF
this would select the curve type

like = Eff or PF or else

so this would mean finding a way to pre define inside the Macro
the data address for each motor size and the selected curve
and keep executing the rest of the spline macro

There must be a way to use a long If statement or else
to define the data address for each motor size and curve

Note:
if needed i can upload a sample file to check and test let me know

so how can this be done ?

any help appreciated

thanks
have a nice day