Changes Information it's not showing !

Discuss the spreadsheet application

Changes Information it's not showing !

Postby im.eugen » Mon Jul 08, 2019 2:28 pm

Hi,

Im new here and i realy need some help if that is posible ....

I have a document that needs to have a time stamp when ever a cel is modified ... i'v tryed to use [ =IF(Q4<>""; IF(R4 =""; NOW(); R4); "") ] and it works fine how ever it works only if the added contet is deleted from the cell, it's not working if im using a Validity > Cell Range drop down selection. and i cant find any version that can work like that ...

So insted i'v tryed to use Changes and relly on the hovering info that is time stamped and more that that it tells you what was changed. Except on one of the sheet's it dosen't whant to work ... it works on the other two sheets but not on the one that i realy need .. and i cant find any information why ..

And yes i did reset the profile ... that did nothing ...

Please help ... i just dont get it ...
Attachments
not showing sheet.png
not showing sheet.png (6.01 KiB) Viewed 201 times
showing sheet.png
showing sheet.png (8.67 KiB) Viewed 201 times
Apache OpenOffice 4.1.6
Runing on Windows 10 Pro
im.eugen
 
Posts: 2
Joined: Mon Jul 08, 2019 2:08 pm

Re: Changes Information it's not showing !

Postby MrProgrammer » Mon Jul 08, 2019 3:44 pm

im.eugen wrote:I have a document that needs to have a time stamp whenever a cell is modified
This feature is not avaiable in Calc. Read section 3. Dates in cells in Ten concepts that every Calc user should know.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3809
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Changes Information it's not showing !

Postby im.eugen » Mon Jul 08, 2019 3:53 pm

MrProgrammer wrote:
im.eugen wrote:I have a document that needs to have a time stamp whenever a cell is modified
This feature is not avaiable in Calc. Read section 3. Dates in cells in Ten concepts that every Calc user should know.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.


Thank you for your imput. Yes i know that now ... that's why i decided to use Changes ... but it seems it dosen't work ...

If any one can tell me why the hower information from Changes dosen't show on all of my sheets when i edit a cell and i select it or just move the pointer over it...?! if i edit on sheet 1 or sheet 3 it works fine ....if i edit a cell on sheet 2 it dosen't show the information...
Apache OpenOffice 4.1.6
Runing on Windows 10 Pro
im.eugen
 
Posts: 2
Joined: Mon Jul 08, 2019 2:08 pm

Re: Changes Information it's not showing !

Postby MrProgrammer » Tue Jul 09, 2019 4:53 pm

Hi, and welcome to the forum.

im.eugen wrote:if i edit a cell on sheet 2 it doesn't show the information
In this situation I would select all the cells, Edit → Copy, open a new spreadsheet, Edit → Paste, and save in ODS format. If you have more than one sheet, use the Insert → Sheet dialog and copy/paste the others to the new file. Then enable Edit → Changes → Record.

Change recording in the file is handled differently by other spreadsheet software, like Excel, so one is asking for trouble to open an OpenOffice spreadsheet (ODS) with change tracking in Excel, or an Excel spreadsheet with change tracking (XLS or XLSX) in OpenOffice. This may not be related to the reason you are having difficulty with that sheet, but I have noticed that people are more likely to have OpenOffice/Excel problems when change recording is in use.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3809
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Changes Information it's not showing !

Postby RoryOF » Tue Jul 09, 2019 4:57 pm

MrProgrammer wrote:[This may not be related to the reason you are having difficulty with that sheet, but I have noticed that people are more likely to have problems OpenOffice/Excel problems when change recording is in use.


This is true, particularly if MS Office file formats are used (.xlsx and .xls).

Note that OpenOffice will read (sort of) .xlsx, but not Save using that format.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29432
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests