Transfer date format from one file to others files at once

Discuss the spreadsheet application

Transfer date format from one file to others files at once

Postby Bokiiiiii » Tue Jan 14, 2020 10:58 pm

I don't use much open office, only when i have to do something for my parents
They have around 1294 files with patients and their data. They have been doing this from 2010.
Somehow now they can't enter the date.Since 1 January 2020, they can't enter the date at all. I tried to fixed that, but now. i need to open each file one by one and to repeat the process. Opening 1294 files i am sure if anyone can do it.

So is there a way to transfer what i did to once file and transfer that to the rest of the files?
OpenOffice 4.1.6 on Windows 10 64bit
Bokiiiiii
 
Posts: 2
Joined: Tue Jan 14, 2020 10:38 pm

Re: transfer date format from one file to others files at on

Postby MrProgrammer » Tue Jan 14, 2020 11:11 pm

Hi, and welcome to the forum.

Bokiiiiii wrote:Somehow now they can't enter the date.Since 1 January 2020, they can't enter the date at all.
• Why can't they enter the date?
• What happens when they enter the date?
• How does what happens differ from what is expected?
Attach a spreadsheet demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).
• Indicate what date you want entered in which cell in which sheet.

Answer all three questions, provide an attachment, and specify: date, cell, sheet.

Bokiiiiii wrote:So is there a way to transfer what i did to [one] file …?
What specifically did you do?
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3937
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: transfer date format from one file to others files at on

Postby Bokiiiiii » Tue Jan 14, 2020 11:18 pm

MrProgrammer wrote:• Why can't they enter the date?
• What happens when they enter the date?

I have no idea

MrProgrammer wrote:• How does what happens differ from what is expected?

When they click the cell in the column DATE, there was a calendar pop up.Now it doesn't show anything,on any file.

MrProgrammer wrote:• Indicate what date you want entered in which cell in which sheet.

Date: Date/Month/Year
Last edited by Hagar Delest on Wed Jan 15, 2020 9:17 am, edited 1 time in total.
Reason: BBCode fixed for quotes
OpenOffice 4.1.6 on Windows 10 64bit
Bokiiiiii
 
Posts: 2
Joined: Tue Jan 14, 2020 10:38 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests