Declaration
Dim currDoc As Object
Dim currSheet As Object
Dim cell As Object
currDoc = ThisComponent
currSheet = currDoc.sheets(0)
Logic
cell.Formula = cDbl(cell.Value)
Desired Output
100,00
Libreoffice Calc Basic How to append 2 decimal places by code
566 Views Asked by Tobi S At
1
There are 1 best solutions below
Related Questions in LIBREOFFICE
- How to switch encoding of LibreOffice strings in Java UNO API?
- Is there a way to automatically export OpenOffice/LibreOffice drawings to bitmaps, with options?
- LibreOffice. Getting OutOfMemoryException while execute Conversion to PDF not instantly, but after long time of work
- Calculate the average of a filtered list/column with a condition (libre office calc)
- LibreOffice converts files from RTF to PDF to plain RTF text
- How to turn off LibreOffice API SDK Reference Browser?
- I compiled LibreOffice on Windows using Cygwin, but after running 'C:/cygwin64/opt/lo/bin/make', I encountered numerous errors
- How do I this shell (.zsh) script to put files into nested folders?
- win32gui SendMessage not working correctly in libreoffice
- Is there a way to program macros to finely tune animations in LibreOffice Impress?
- problem invoking msgbox after closing one document in python. object has no attribute 'getCurrentController'
- Add Image to Libre Office Writer with VB.Net
- How do I get content of a text cursor in Libreoffice Writer?
- How to convert excel to PDF using nodeJS? Getting issues using libreoffice-convert
- Libreoffice classes not available in java code
Related Questions in OPENOFFICE.ORG
- LibreOffice - How to create a file dialog via python macro?
- couldn't connect to socket (WSANOTINITIALISED, WSAStartup() has not been called) error while running program
- Not able to execute a class with external class path
- DDEML connection fails after large number of calls
- Preview MSOffice files in .NET WPF app via OpenOffice/LibreOffice
- cast exception while using OpenOffice SDK to create a DataSource
- Lack of access to all functions in exposed interfaces?
- OpenOffice convert doc to pdf with JAVA
- Where to find latest OpenOffice dictionaries?
- Netbeans OpenOffice Plugin throw error
- Installation of openoffice 4.0 for open erp
- Spreadsheet Help: Adding Multiple Rows With "If" Function
- XStorable storeToURL and WebDav
- How to debug crashing openoffice with pyuno
- Openoffice pipe (unix domain socket) somewhere other than /tmp?
Related Questions in BASIC
- Visual Basic - Button on website doesnt have an ID
- QuickBASIC variable only used on one line.
- Visual basic and Json.net Web request
- UDF/User defined function libreoffice basic with built-in help/tip
- VBA - An outgoing call cannot be made since the application is dispatching an input-synchronous call
- Opening buttons to Mainwin?
- Excel Macro to create school reports
- How can I get a random multiple of 50 using Microsoft Small Basic?
- Updating SQL database with datagridview contents
- Checksum without logic/bitwise operations
- How to get user to enter in 24 hour format in BBC Basic
- decoding an ASCII character message
- How to use Randomize to choose from array list
- redefinition; different basic types
- Visual Basic - How to use a variable from one function in another
Related Questions in LIBREOFFICE-BASIC
- How to query image information in a Libreoffice macro?
- How to select entire row in a Libreoffice Basic macro?
- A macro to remove the first space
- Get and set local/web hyperlinks in Libre office Impress shape element using basic macro
- Convert working VBA macro into libre basic
- Unable to change shape color using macro in LibreOffice Impress presentation mode
- Remove save keyboard shortcut using script
- Paste formula in Libre Calc using Basic macro
- LibreOffice, Writer, Macros, How to replace a embedded object formula with its string contents
- Excel Formula to validate valid IP and valid URL in librecalc excel sheet
- Writing libreoffice-calc macros in Visual Studio Code
- Insert image into LibreOffice as Link using API/Macro
- libeoffice conected to oracle registeroutparameter to return resultset
- LibreOffice Calc Input Box and mathematical expressions
- Libre Calc - Populate Cells from CSV string
Related Questions in OPENOFFICE-BASIC
- How can I colorize all merged cells with a sheet of Open Office-Calc?
- A way to add subroutines by code at runtime in libreoffice basic
- creating a new module in a chosen library using libreoffice basic
- Macro OpenOffice Writer: next record
- OpenOffice - Macro if condition
- How to run a formula until it meets a certain criteria?
- getScriptProvider and createScriptProvider in Libre/Open/Collabra Office
- How to use variable in openoffice basic's formular?
- Styling cells with macro
- How to write macro for OpenOffice Writer to remove all index markerkers
- Is there a way to count the number of actual replaces when using replaceAll in OO Basic?
- How to use Imports System.Xml in Open Office (Basic)?
- Recalc Pivot Table with Basic API
- How to run a script from another document
- Libreoffice Calc Basic How to append 2 decimal places by code
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
based on @JohnSUN 's comment: Just add one line for your cell to be formatted:
Table for all Numberformats on page 189