Re: [libreoffice-users] full date string to date

2019-12-30 Thread James 


On 2019-12-30 4:43 p.m., Alan B wrote:

James,

The only way I could get the text sample you provided to be accepted 
as a date was to leave the day name off. Typing Wed, Jan 2, 2020 into 
a cell resulted in a cell that contained text. Typing Jan 2, 2020 into 
a cell resulted in a cell that contained a date in the default date 
format, mm/dd/yy. That could then be formatted to NN, MMM D,  and 
display as Wed, Jan 2, 2020.


The DATEVALUE() function will convert the string Jan 2, 2020 to a 
date. It returns Err:502 when pointed at the string Wed, Jan 2, 2020.


My suggestion would be to input the substring Jan 2, 2020 into the 
DATEVALUE function then format as desired to get your dates back.


e.g. =DATEVALUE(MID(A1,6,20))


That works, thanks.

I have a spreadsheet with 2018 dates and I did a replace of '2018' for 
'2019' to make a copy of the spreadsheet for 2019.

When I did the replace for 2020 dates it changed the cells to text.
I maybe had an option checked that I didn't before. :-(




On Mon, Dec 30, 2019 at 2:55 PM James > wrote:


I had a spreadsheet with dates that I think somehow got converted
to text.
I tried pasting it as plain text with detecting special numbers and I
tried setting the column to a date format but it still seems to
come out
as text.

'Wed, Jan 2, 2020'


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org


Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Please take me off this list

2019-12-30 Thread Diana Ziemniak 


Unsubscribe me please
Sent from my iPhone

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] full date string to date

2019-12-30 Thread Brian Barker 

At 14:39 30/12/2019 -0500, James Lockie wrote:
I had a spreadsheet with dates that I think somehow got converted to 
text. I tried pasting it as plain text with detecting special 
numbers and I tried setting the column to a date format but it still 
seems to come out as text. 'Wed, Jan 2, 2020'


Dates are sensitive to language and locale, so no guarantees, but 
...; you should be able to convert your data using the spreadsheet 
program's own facilities. Try this:


o Suppose your date data is in column A. Select the range (or column) 
and go to Data | Text to Columns... .  Under Separator options, tick 
Comma, Space, and Merge delimiters. OK. You now have the four parts 
of your dates separately in columns A, B, C, and D.


o In the first row of your data in a new column, enter (for, say, row 1)
=DATEVALUE(C1)
- and fill down the column. Note the jumbled order of the parameters, 
so what is offered to the DATEVALUE() function is three parts of your 
date concatenated as "2Jan2020".


o Format the values in the new column as desired, perhaps as
NN, MMM D, 

You can copy the resulting values back over the originals if you wish 
- or elsewhere, of course - using Paste Special with Formulae unticked.


Oh, and by the way, unless something very strange is about to happen, 
I'm expecting 2 January 2020 to be a Thursday, not a Wednesday!


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] full date string to date

2019-12-30 Thread Alan B 
James,

The only way I could get the text sample you provided to be accepted as a
date was to leave the day name off. Typing Wed, Jan 2, 2020 into a cell
resulted in a cell that contained text. Typing Jan 2, 2020 into a cell
resulted in a cell that contained a date in the default date format,
mm/dd/yy. That could then be formatted to NN, MMM D,  and display as
Wed, Jan 2, 2020.

The DATEVALUE() function will convert the string Jan 2, 2020 to a date. It
returns Err:502 when pointed at the string Wed, Jan 2, 2020.

My suggestion would be to input the substring Jan 2, 2020 into the
DATEVALUE function then format as desired to get your dates back.

e.g. =DATEVALUE(MID(A1,6,20))

On Mon, Dec 30, 2019 at 2:55 PM James  wrote:

> I had a spreadsheet with dates that I think somehow got converted to text.
> I tried pasting it as plain text with detecting special numbers and I
> tried setting the column to a date format but it still seems to come out
> as text.
>
> 'Wed, Jan 2, 2020'
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>


-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] full date string to date

2019-12-30 Thread James 

I had a spreadsheet with dates that I think somehow got converted to text.
I tried pasting it as plain text with detecting special numbers and I 
tried setting the column to a date format but it still seems to come out 
as text.


'Wed, Jan 2, 2020'


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] View issues with 6.07 from Ubuntu repositories

2019-12-30 Thread John Jason Jordan 
On Mon, 30 Dec 2019 09:48:40 +0100
Heiko Tietze  dijo:

>Do you scale the UI for some reason, eg. font size 125%?

Sort of. Different parts are set with varying methods. However,
percentages are never used except in web browsers. Fonts are set with
points. Icons and most other matters are set with pixels.

I could scale the entire thing by changing the resolution with xrandr,
e.g., from the native 3840x2160 down to 1920x1080. But why? I didn't
pay for a 4K monitor to run it at 2K.

The problem is that the desktop environment (I use Xfce) has at least
two different settings for icon size, and half a dozen for point size
of text. For example, the window title bar text is one setting, toolbar
text is another setting (which LO does not always respect, by the way),
body text is another setting, and so on.

Although I now have the Styles and Formatting toolbar visible, LO fails
to respect the line spacing of the desktop environment. And someone
decided to hard-code the spacing as a number of pixels for the main
toolbar so, since I had to set the toolbar text big enough to see, the
items appear somewhat smashed together:
FileEditInsertFormatTableToolsLinguisticsWindowHelp.
[Edit: This issue seems to have been resolved with LO
6.3.4.2.] LO is not the only application where column widths are
hard-coded as a number of pixels; I have the same problem with a few
other applications. And many applications, including LO, hard-code the
icon size in toolbars, so the icons are 2-3mm high. For example, in the
Styles and Formatting toolbar I have to hover over an icon to read its
tool-tip in order to know what the icon does. And someone coded the
Styles and Formatting window to be an application window instead of a
toolbar window, so 'Styles and Formatting' is the same point size as
the main window. It all works, it just looks weird.

That's enough of a rant. I'll shut up now. :)

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] View issues with 6.07 from Ubuntu repositories

2019-12-30 Thread Heiko Tietze 
Do you scale the UI for some reason, eg. font size 125%?

On 29.12.19 00:06, John Jason Jordan wrote:
> I had LO 6.3.3.2 installed, downloaded from LO. But I was unable to
> correct the line spacing in the Styles and Formatting toolbar, and
> trying to fix it I discovered that it would hang if I clicked on Tools >
> Customize. After much effort I gave up and uninstalled 6.3.3.2, and
> then installed 6.07 from the Ubuntu repositories. Tools > Customize
> no longer hangs the program, but now I have other problems.
> 
> I keep my toolbars floating off to the right. Here is an image:
> https://imgur.com/YISfwld
> 
> The Formatting toolbar was missing more than half the icons, replaced
> with the text for the function. For example, instead of an icon showing
> a character with a line above it, I saw just 'overline.' I tried to add
> the correct icon by customizing the toolbar, but there were only a
> couple dozen icons available, and none for overline. I have installed
> all the themes I can find and, although in Tools > Options I can now
> select different sets of icons, the only one which has all the icons is
> Breeze. Are there more icon sets available somewhere?
> 
> There is an even worse problem. I cannot view the Styles and Formatting
> toolbar at all. When I select it the toolbar flashes for a split second
> on the screen and then disappears. It doesn't matter if I select it
> with Formatting > Styles and Formatting or with F11. With 6.3.3.2 the
> line spacing for the styles was off, and now the toolbar can't even be
> viewed. I'm going from bad to worse.
> 
> Furthermore, the scrollbars are the thickness of a pencil lead; just
> about impossible to hit with the mouse. I know that this is because of
> an issue with gtk3, but the gtk3 integration package is properly
> installed. The scrollbars appear correctly in all my other
> applications, so I don't know why they are unusable in LO.
> 
> LO is unusable without styles and scrollbars. Can someone offer
> suggestions for how to fix these issues?
> 

-- 
Dr. Heiko Tietze, UX-Designer and UX-Mentor
Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: https://www.documentfoundation.org/imprint


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy