Getting date of last change as a cell value in Open Office CalcIs it Possible to not copy all 65,537 cells...
In 'Revenger,' what does 'cove' come from?
ssTTsSTtRrriinInnnnNNNIiinngg
How would I stat a creature to be immune to everything but the Magic Missile spell? (just for fun)
What's the in-universe reasoning behind sorcerers needing material components?
Is it possible to create a QR code using text?
How much of data wrangling is a data scientist's job?
Venezuelan girlfriend wants to travel the USA to be with me. What is the process?
How could indestructible materials be used in power generation?
Do scales need to be in alphabetical order?
A category-like structure without composition?
Avoiding direct proof while writing proof by induction
How dangerous is XSS?
What reasons are there for a Capitalist to oppose a 100% inheritance tax?
Why was the shrinking from 8″ made only to 5.25″ and not smaller (4″ or less)?
Is there an expression that means doing something right before you will need it rather than doing it in case you might need it?
How to show a landlord what we have in savings?
What do you call someone who asks many questions?
Arrow those variables!
Why are the 737's rear doors unusable in a water landing?
Can my sorcerer use a spellbook only to collect spells and scribe scrolls, not cast?
Could the museum Saturn V's be refitted for one more flight?
Expand and Contract
How to Recreate this in LaTeX? (Unsure What the Notation is Called)
Why is consensus so controversial in Britain?
Getting date of last change as a cell value in Open Office Calc
Is it Possible to not copy all 65,537 cells when copying a column in Open OfficeFocus last modified cell when opening ExcelHow to reference individual cells in Excel to variable data from records in an external SQL tableCount instances of a letter in a row if a certain cell in that row contains a specified dateIn excel how can I select a range of cells below a cell that matches a certain valueHow can I disable changes to folder last modified date?Getting last cell in row with data and corresponding data in column A in ExcelPrevent OpenOffice Calc from converting pasted numbers with decimals into datesLook up table values in different worksheets to create summary (VLOOKUP, HLOOKUP, INDIRECT)Excel 2013-Force Date Format in a Cell
I have a few Open Office spreadsheet files (let us call them source files), each containing the financial info of a particular office of ours. I also have a summary spreadsheet, that reads some key data about the offices and does some analysis.
For the analysis, I would like to know also, how outdated the individual source files, when was the last time the offices updated their data. Is there a way to access the "Last time modified" and/or "Time of creation" file system properties of the source files from Open Office, and import the date into a given cell?
Alternative solutions are also OK, as long as I get the date of last change of the source files into the cells of the summary spreadsheet.
microsoft-excel filesystems openoffice-calc libreoffice-calc
asked Mar 29 '13 at 21:41
user24752user24752
1731214
add a comment |
I have a few Open Office spreadsheet files (let us call them source files), each containing the financial info of a particular office of ours. I also have a summary spreadsheet, that reads some key data about the offices and does some analysis.
For the analysis, I would like to know also, how outdated the individual source files, when was the last time the offices updated their data. Is there a way to access the "Last time modified" and/or "Time of creation" file system properties of the source files from Open Office, and import the date into a given cell?
Alternative solutions are also OK, as long as I get the date of last change of the source files into the cells of the summary spreadsheet.
microsoft-excel filesystems openoffice-calc libreoffice-calc
asked Mar 29 '13 at 21:41
user24752user24752
1731214
add a comment |
I have a few Open Office spreadsheet files (let us call them source files), each containing the financial info of a particular office of ours. I also have a summary spreadsheet, that reads some key data about the offices and does some analysis.
For the analysis, I would like to know also, how outdated the individual source files, when was the last time the offices updated their data. Is there a way to access the "Last time modified" and/or "Time of creation" file system properties of the source files from Open Office, and import the date into a given cell?
Alternative solutions are also OK, as long as I get the date of last change of the source files into the cells of the summary spreadsheet.
microsoft-excel filesystems openoffice-calc libreoffice-calc
asked Mar 29 '13 at 21:41
user24752user24752
1731214
I have a few Open Office spreadsheet files (let us call them source files), each containing the financial info of a particular office of ours. I also have a summary spreadsheet, that reads some key data about the offices and does some analysis.
For the analysis, I would like to know also, how outdated the individual source files, when was the last time the offices updated their data. Is there a way to access the "Last time modified" and/or "Time of creation" file system properties of the source files from Open Office, and import the date into a given cell?
Alternative solutions are also OK, as long as I get the date of last change of the source files into the cells of the summary spreadsheet.
microsoft-excel filesystems openoffice-calc libreoffice-calc
microsoft-excel filesystems openoffice-calc libreoffice-calc
asked Mar 29 '13 at 21:41
user24752user24752
1731214
asked Mar 29 '13 at 21:41
user24752user24752
1731214
asked Mar 29 '13 at 21:41
user24752user24752
1731214
asked Mar 29 '13 at 21:41
user24752user24752
1731214
asked Mar 29 '13 at 21:41
user24752user24752
1731214
1731214
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
The closest thing I've found for libreoffice is the NOW() function. The internet has many Excel-related answers that require visual basic. See for example
http://www.sumproduct.com/thought/creating-a-timestamp
Hope you (and I!) get a good answer some day, but 9 months on I suppose we will have to live without a bit longer...
answered Jan 23 '14 at 4:20
Rob LathamRob Latham
1012
add a comment |
I keep seeing questions about getting the last file modification date in a Calc cell with no good answers. Below is the code I use. Add it as a macro to your spreadsheet.
Function CalcDoc_Modify_Date()
Dim sTemp
' work with DocInfo
With ThisComponent.DocumentProperties.ModificationDate
' set return format
' force month and day to two digits
sTemp = _
Format( .Month, "0#" ) & "/" & _
Format( .Day, "0#" ) & "/" & _
.Year & " " & _
Format( .Hours, "0#" ) & ":" & _
Format( .Minutes, "0#" )
End With
' assign func return value
CalcDoc_Modify_Date = sTemp
End Function
In your spreadsheet, enter =CALCDOC_MODIFY_DATE() in a cell to call this function.
edited 50 secs ago
phuclv
10.6k64296
answered Nov 25 '16 at 21:52
AlexJAlexJ
112
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f575460%2fgetting-date-of-last-change-as-a-cell-value-in-open-office-calc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The closest thing I've found for libreoffice is the NOW() function. The internet has many Excel-related answers that require visual basic. See for example
http://www.sumproduct.com/thought/creating-a-timestamp
Hope you (and I!) get a good answer some day, but 9 months on I suppose we will have to live without a bit longer...
answered Jan 23 '14 at 4:20
Rob LathamRob Latham
1012
add a comment |
The closest thing I've found for libreoffice is the NOW() function. The internet has many Excel-related answers that require visual basic. See for example
http://www.sumproduct.com/thought/creating-a-timestamp
Hope you (and I!) get a good answer some day, but 9 months on I suppose we will have to live without a bit longer...
answered Jan 23 '14 at 4:20
Rob LathamRob Latham
1012
add a comment |
The closest thing I've found for libreoffice is the NOW() function. The internet has many Excel-related answers that require visual basic. See for example
http://www.sumproduct.com/thought/creating-a-timestamp
Hope you (and I!) get a good answer some day, but 9 months on I suppose we will have to live without a bit longer...
answered Jan 23 '14 at 4:20
Rob LathamRob Latham
1012
The closest thing I've found for libreoffice is the NOW() function. The internet has many Excel-related answers that require visual basic. See for example
http://www.sumproduct.com/thought/creating-a-timestamp
Hope you (and I!) get a good answer some day, but 9 months on I suppose we will have to live without a bit longer...
answered Jan 23 '14 at 4:20
Rob LathamRob Latham
1012
answered Jan 23 '14 at 4:20
Rob LathamRob Latham
1012
answered Jan 23 '14 at 4:20
Rob LathamRob Latham
1012
answered Jan 23 '14 at 4:20
Rob LathamRob Latham
1012
1012
add a comment |
add a comment |
I keep seeing questions about getting the last file modification date in a Calc cell with no good answers. Below is the code I use. Add it as a macro to your spreadsheet.
Function CalcDoc_Modify_Date()
Dim sTemp
' work with DocInfo
With ThisComponent.DocumentProperties.ModificationDate
' set return format
' force month and day to two digits
sTemp = _
Format( .Month, "0#" ) & "/" & _
Format( .Day, "0#" ) & "/" & _
.Year & " " & _
Format( .Hours, "0#" ) & ":" & _
Format( .Minutes, "0#" )
End With
' assign func return value
CalcDoc_Modify_Date = sTemp
End Function
In your spreadsheet, enter =CALCDOC_MODIFY_DATE() in a cell to call this function.
edited 50 secs ago
phuclv
10.6k64296
answered Nov 25 '16 at 21:52
AlexJAlexJ
112
add a comment |
I keep seeing questions about getting the last file modification date in a Calc cell with no good answers. Below is the code I use. Add it as a macro to your spreadsheet.
Function CalcDoc_Modify_Date()
Dim sTemp
' work with DocInfo
With ThisComponent.DocumentProperties.ModificationDate
' set return format
' force month and day to two digits
sTemp = _
Format( .Month, "0#" ) & "/" & _
Format( .Day, "0#" ) & "/" & _
.Year & " " & _
Format( .Hours, "0#" ) & ":" & _
Format( .Minutes, "0#" )
End With
' assign func return value
CalcDoc_Modify_Date = sTemp
End Function
In your spreadsheet, enter =CALCDOC_MODIFY_DATE() in a cell to call this function.
edited 50 secs ago
phuclv
10.6k64296
answered Nov 25 '16 at 21:52
AlexJAlexJ
112
add a comment |
I keep seeing questions about getting the last file modification date in a Calc cell with no good answers. Below is the code I use. Add it as a macro to your spreadsheet.
Function CalcDoc_Modify_Date()
Dim sTemp
' work with DocInfo
With ThisComponent.DocumentProperties.ModificationDate
' set return format
' force month and day to two digits
sTemp = _
Format( .Month, "0#" ) & "/" & _
Format( .Day, "0#" ) & "/" & _
.Year & " " & _
Format( .Hours, "0#" ) & ":" & _
Format( .Minutes, "0#" )
End With
' assign func return value
CalcDoc_Modify_Date = sTemp
End Function
In your spreadsheet, enter =CALCDOC_MODIFY_DATE() in a cell to call this function.
edited 50 secs ago
phuclv
10.6k64296
answered Nov 25 '16 at 21:52
AlexJAlexJ
112
I keep seeing questions about getting the last file modification date in a Calc cell with no good answers. Below is the code I use. Add it as a macro to your spreadsheet.
Function CalcDoc_Modify_Date()
Dim sTemp
' work with DocInfo
With ThisComponent.DocumentProperties.ModificationDate
' set return format
' force month and day to two digits
sTemp = _
Format( .Month, "0#" ) & "/" & _
Format( .Day, "0#" ) & "/" & _
.Year & " " & _
Format( .Hours, "0#" ) & ":" & _
Format( .Minutes, "0#" )
End With
' assign func return value
CalcDoc_Modify_Date = sTemp
End Function
In your spreadsheet, enter =CALCDOC_MODIFY_DATE() in a cell to call this function.
edited 50 secs ago
phuclv
10.6k64296
answered Nov 25 '16 at 21:52
AlexJAlexJ
112
edited 50 secs ago
phuclv
10.6k64296
edited 50 secs ago
phuclv
10.6k64296
edited 50 secs ago
phuclv
10.6k64296
10.6k64296
answered Nov 25 '16 at 21:52
AlexJAlexJ
112
answered Nov 25 '16 at 21:52
AlexJAlexJ
112
answered Nov 25 '16 at 21:52
AlexJAlexJ
112
112
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f575460%2fgetting-date-of-last-change-as-a-cell-value-in-open-office-calc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
