How do I get the cell value?

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
supernam
Posts: 8
Joined: Thu Jan 04, 2018 9:08 am

How do I get the cell value?

Post by supernam »

Hi All,

I modify cell value on a openoffice file, but I did not save and close the file, how do I get the modified value or modified state?
How can I do it with python?

Thanks
OpenOffice 1.4 on Linux
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How do I get the cell value?

Post by Zizi64 »

I modify cell value on a openoffice file, but I did not save and close the file, how do I get the modified value or modified state?
The built-in event ""Modified" status was changed" raises once after modifying a document. The save procedure resets the flag, and the the fist modification will set the "Modified" flag. You can assign your macro this event, and you can reset the "Modified" flag by your macro code.

Tools - Customize - Events - "Modified" status was changed

Or you can write your own listeners:
viewtopic.php?f=20&t=30516

How can I do it with python?
I do not know it.
You need use the API functions of the office suite for every supported programming languages. But I never used the Python.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply