Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › OpenOffice Calc Macro Help
New Posts  All Forums:Forum Nav:

OpenOffice Calc Macro Help

post #1 of 2
Thread Starter 
Alright guys I need some help, I am creating a spreadsheet in Calc (OpenOffice's equivalent to Excel) and I am having trouble putting a permanent time stamp.

So let's say cell A1 is a drop down list that contains the options Yes and No. If A1 is yes it would add a time stamp to A2, if A1 is No then A2 would be blank. I can't use the NOW() function itself because as soon I edit a different cell anywhere in the document it updates the time to a different value. The only solution i have found for a permanent time stamp is by using a Macro. Is there a way I can make Calc run the macro when cell A1 is set to Yes?

P.S. I had no idea where to post this thread so I settled with Coding since it uses Basic. If I was wrong could a Mod please move it to the right location.
S11
(17 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS Z77 Sabertooth ATI Radeon 5450HD Corsair Dominator Platinum 
Hard DriveHard DriveOptical DriveCooling
240Gb Cosair Force GT 500Gb Western Digital Blue ASUS BW-12B1ST Corsair H100i 
CoolingCoolingOSMonitor
Corsair 200mm Fan (x2) Corsair SP120 Quiet Edition Windows 8 X-Star DP2710 
KeyboardPowerCaseMouse
Corsair K90 Corsair HX1050 Corsair Obsidian 650D Corsair M90 
Other
Corsair Link Cooling And Lighting Kit 
  hide details  
Reply
S11
(17 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770K ASUS Z77 Sabertooth ATI Radeon 5450HD Corsair Dominator Platinum 
Hard DriveHard DriveOptical DriveCooling
240Gb Cosair Force GT 500Gb Western Digital Blue ASUS BW-12B1ST Corsair H100i 
CoolingCoolingOSMonitor
Corsair 200mm Fan (x2) Corsair SP120 Quiet Edition Windows 8 X-Star DP2710 
KeyboardPowerCaseMouse
Corsair K90 Corsair HX1050 Corsair Obsidian 650D Corsair M90 
Other
Corsair Link Cooling And Lighting Kit 
  hide details  
Reply
post #2 of 2
You really should be doing this in a database rather than a spreadsheet. Even if you're just managing that database with LibreOffice Database / MS Access. This sort of stuff isn't meant for spreadsheets so you're creating a bigger job for yourself in the long run.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › OpenOffice Calc Macro Help