does exist a sound function in Libre Office Calc just like in Basic language

JoseR1 · July 14, 2020, 5:50pm

I need to simulate the sound reproduction of a programmable oscillator built with an LM555P timer having the output thru the PC speaker according to the formula F=1.44/(Ra + 2Rb)/C.

jimk · July 15, 2020, 5:47pm

What Basic language function? Perhaps you mean the .NET Console.Beep method.

jimk · July 15, 2020, 5:44pm

In LibreOffice Basic, the following worked for me on Windows. From System.Console.BeepBeep(frequency, duration) (View topic) • Apache OpenOffice Community Forum

Private Declare Function Beep Lib "kernel32" (ByVal dwFreq As Long, ByVal dwDuration As Long) As Long
Sub press
	freq = 500
	duration = 10
	Call Beep(freq, duration)
End Sub

If this doesn’t work, try a Python macro on Windows. Create and run it with APSO.

import winsound
winsound.Beep(frequency=1000, duration=500)

On Linux, a package must be installed. Then do a system call. The code for both Basic and Python is below.

sudo apt-get install beep

Shell("beep -f 1000 -n -f 2000 -n -f 1500 ")

os.system('beep -f %s -l %s' % (frequency,duration))