Using the "Preview in web browser feature"
from a sheet that has data and dates on it
Then ... copying from the browser and pasting to the same sheet
the DATES come back as a numbers not DATES.
The browser shows the dates as dates.
This is a new issue. Same browser. Same open office . Same computer.
Any ideas people?
thanks - alexandra
[Solved] Preview in web browser issue
-
- Posts: 53
- Joined: Sat Mar 21, 2015 9:13 pm
[Solved] Preview in web browser issue
Last edited by Hagar Delest on Tue Apr 13, 2021 8:57 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
OPEN OFFICE 4.1.1 ON WINDOWS 7
-
- Posts: 53
- Joined: Sat Mar 21, 2015 9:13 pm
solved Re: Preview in web browser issue
Okay. So I found a remedy. Not a fix mind you. A remedy. I used a new spreadsheet. Set the style and formatting the same as the original spreadsheet i was previous using and viola - the dates came out as dates like they are supposed to. Don't know what the problem was with the other spreadsheet but I guess it's solved for now.
Thanks for looking
alexandra
Thanks for looking
alexandra
OPEN OFFICE 4.1.1 ON WINDOWS 7
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Preview in web browser issue
Dates are numbers in fact. They are just displayed differently than a standard number.
Do you mean that pasting from the web preview in your second spreadsheet is fine?
Do you mean that pasting from the web preview in your second spreadsheet is fine?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
-
- Posts: 53
- Joined: Sat Mar 21, 2015 9:13 pm
Re: Preview in web browser issue
Thanks
Yes that works fine! The second one. Strange highways, The first sheet that's set up identically still didn't work. So that sheet is gone now. Couldn't figure why one sheet works and the other doesn't. Like people I guess. People who love to work and people who look to avoid work ... but still get paid!
thanks Mr H
Yes that works fine! The second one. Strange highways, The first sheet that's set up identically still didn't work. So that sheet is gone now. Couldn't figure why one sheet works and the other doesn't. Like people I guess. People who love to work and people who look to avoid work ... but still get paid!
thanks Mr H
OPEN OFFICE 4.1.1 ON WINDOWS 7