LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-02-2016, 03:12 PM   #1
littlejoe5
Member
 
Registered: Aug 2006
Location: Arizona
Distribution: Various Debian derivitives
Posts: 258

Rep: Reputation: 19
libreoffice.calc formula to apply current date to individual rows.


I'm having an awful time with formulas in libreoffice.calc.

I'm trying to set a column in libreoffice.calc to keep a record of entries or changes by row. The formula I've put together doesn't to anything that I can see.

This 'spreadsheet' has little to do with numbers, but rather with contacts. What I need is a formula to put a date in one column (year,month,day) for each line when it is entered, and update when anything in that row is changed.

So-far nothing that I have tried even produces a date. "=DATE" "=TODAY"
 
Old 12-02-2016, 03:30 PM   #2
dolphin_oracle
MX Linux
 
Registered: Dec 2013
Posts: 402

Rep: Reputation: Disabled
usually functions end in ()

Code:
=today()
 
Old 12-03-2016, 12:01 PM   #3
DavidMcCann
LQ Veteran
 
Registered: Jul 2006
Location: London
Distribution: PCLinuxOS, Xubuntu
Posts: 5,448

Rep: Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899
Download the user guide and it will tell you all you'll ever need to know!
https://wiki.documentfoundation.org/...alcGuideLO.pdf
 
Old 12-03-2016, 12:25 PM   #4
Steve R.
Member
 
Registered: Jun 2009
Location: Morehead City, NC
Distribution: Ubuntu 16.04
Posts: 418

Rep: Reputation: 74
Quote:
Originally Posted by littlejoe5 View Post
This 'spreadsheet' has little to do with numbers, but rather with contacts.
A misuses of what a spreadsheet is supposed to be about. A better approach would be to use a database.
 
Old 12-04-2016, 11:51 AM   #5
DavidMcCann
LQ Veteran
 
Registered: Jul 2006
Location: London
Distribution: PCLinuxOS, Xubuntu
Posts: 5,448

Rep: Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899Reputation: 1899
The best approach is always to use what's most convenient for you, and a spreadsheet can be perfectly adequate for simple data, as any Lotus-1-2-3 veteran knows!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
OpenOffice Calc formula needed faizlo Linux - Software 1 01-29-2013 08:08 PM
[SOLVED] Formula Locking In LibreOffice Calc cin_ Linux - Software 2 11-19-2012 06:12 AM
Help Please - Open Office CALC Formula's SangrelX Linux - Software 1 06-23-2009 10:42 PM
elapsed time formula for open office calc philosophe Linux - Software 1 03-30-2005 06:32 AM
OpenOffice Calc formula question Bigun Linux - Software 2 08-16-2004 04:07 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:59 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration