Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.apps.spreadsheets > #63 > unrolled thread

Google Sheets: Date Format

Started byAndreas Borutta <borumat@gmx.de>
First post2018-08-02 08:34 +0200
Last post2018-08-11 07:51 +0000
Articles 6 — 3 participants

Back to article view | Back to comp.apps.spreadsheets


Contents

  Google Sheets: Date Format Andreas Borutta <borumat@gmx.de> - 2018-08-02 08:34 +0200
    Re: Google Sheets: Date Format Luuk <luuk@invalid.lan> - 2018-08-04 10:51 +0200
      Re: Google Sheets: Date Format Andreas Borutta <borumat@gmx.de> - 2018-08-04 11:05 +0200
      Re: Google Sheets: Date Format Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-08-04 11:28 +0000
        Re: Google Sheets: Date Format Luuk <luuk@invalid.lan> - 2018-08-04 13:42 +0200
          File bugs against Google Sheets (was: Google Sheets: Date Format) Eike Rathke <erack-nutznetz.n@posteo.de> - 2018-08-11 07:51 +0000

#63 — Google Sheets: Date Format

FromAndreas Borutta <borumat@gmx.de>
Date2018-08-02 08:34 +0200
SubjectGoogle Sheets: Date Format
Message-ID<c1n7oh11fv3a.dlg@borumat.de>
Hi.

In Google Sheets the format code "ddd" for e.g. 2018/08/01 results in 
"Mi." (German interface)

I need it without the dot. Just "Mi".

Is that possible?

The page 
https://developers.google.com/sheets/api/guides/formats
doesn't give a hint how to solve the problem.

Thanks for your help.

Andreas
-- 
http://fahrradzukunft.de

[toc] | [next] | [standalone]


#64

FromLuuk <luuk@invalid.lan>
Date2018-08-04 10:51 +0200
Message-ID<5b6568fa$0$2945$e4fe514c@news.xs4all.nl>
In reply to#63
On 2-8-2018 08:34, Andreas Borutta wrote:
> Hi.
> 
> In Google Sheets the format code "ddd" for e.g. 2018/08/01 results in 
> "Mi." (German interface)
> 
> I need it without the dot. Just "Mi".
> 
> Is that possible?
> 
> The page 
> https://developers.google.com/sheets/api/guides/formats
> doesn't give a hint how to solve the problem.
> 
> Thanks for your help.
> 
> Andreas
> 

there was a discussion about this on the internet in 2003:
https://www.typografie.info/3/topic/28675-abk%C3%BCrzungspunkt-nach-wochentag/

The writers there where not clear about the right way to go ... ;)

But, praise yourself lucky you do not live in Catalonia
(
https://www.quora.com/How-are-days-of-the-week-abbreviated-in-various-languages
)


The real solution would be to find out how the days of the week are
shortened officially, and than (if this calls for a change) file a bug
report with Google )

[toc] | [prev] | [next] | [standalone]


#65

FromAndreas Borutta <borumat@gmx.de>
Date2018-08-04 11:05 +0200
Message-ID<g1iygt5dcjj0$.dlg@borumat.de>
In reply to#64
Luuk schrieb:

> On 2-8-2018 08:34, Andreas Borutta wrote:
 
>> In Google Sheets the format code "ddd" for e.g. 2018/08/01 results in 
>> "Mi." (German interface)
>> 
>> I need it without the dot. Just "Mi".

> there was a discussion about this on the internet in 2003:
> https://www.typografie.info/3/topic/28675-abk%C3%BCrzungspunkt-nach-wochentag/
> 
> The writers there where not clear about the right way to go ... ;)
> 
> But, praise yourself lucky you do not live in Catalonia
> (
> https://www.quora.com/How-are-days-of-the-week-abbreviated-in-various-languages
> )
> 
> 
> The real solution would be to find out how the days of the week are
> shortened officially, and than (if this calls for a change) file a bug
> report with Google )

Thanks for your hints.



Andreas
-- 
http://fahrradzukunft.de

[toc] | [prev] | [next] | [standalone]


#66

FromEike Rathke <erack-nutznetz.n@posteo.de>
Date2018-08-04 11:28 +0000
Message-ID<N3e8I5b658db4T775a@kulungile.erack.de>
In reply to#64
* Luuk, 2018-08-04 08:51 UTC:
> file a bug report with Google

How does one file a bug against Google Sheets btw?

  Eike

-- 
OpenPGP/GnuPG encrypted mail preferred in all private communication.
GPG key 0x6A6CD5B765632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Use LibreOffice! https://www.libreoffice.org/

[toc] | [prev] | [next] | [standalone]


#67

FromLuuk <luuk@invalid.lan>
Date2018-08-04 13:42 +0200
Message-ID<5b659126$0$2950$e4fe514c@news.xs4all.nl>
In reply to#66
On 4-8-2018 13:28, Eike Rathke wrote:
> * Luuk, 2018-08-04 08:51 UTC:
>> file a bug report with Google
> 
> How does one file a bug against Google Sheets btw?
> 
>   Eike
> 

Start Googling for: report bug google sheets

First Link (for /me):
https://stackoverflow.com/questions/12106497/how-to-report-a-bug-for-google-drive-google-docs

The page contains a link to the 'Google Help forum':
https://productforums.google.com/forum/?visit_id=1-636689793037879714-2750156247&hl=en&rd=1#!forum/docs

But, indeed, there is mentioned that this might be a 'problem':
<quoot>Reporting issues to Google has always been a nightmare. –
Sébastien Jan 2 '14 at 10:18</quoot>

Also:
https://productforums.google.com/forum/#!topicsearchin/docs/category$3Areport-an-issue%7Csort:relevance%7Cspell:false

https://cloud.google.com/support/docs/issue-trackers

[toc] | [prev] | [next] | [standalone]


#68 — File bugs against Google Sheets (was: Google Sheets: Date Format)

FromEike Rathke <erack-nutznetz.n@posteo.de>
Date2018-08-11 07:51 +0000
SubjectFile bugs against Google Sheets (was: Google Sheets: Date Format)
Message-ID<N3e8I5b6e9550T147f@kulungile.erack.de>
In reply to#67
* Luuk, 2018-08-04 11:42 UTC:
> On 4-8-2018 13:28, Eike Rathke wrote:
>> * Luuk, 2018-08-04 08:51 UTC:
>>> file a bug report with Google
>> How does one file a bug against Google Sheets btw?

> Start Googling for: report bug google sheets
> [... some links ...]

Of which none leads to a bug tracker of any sort but all some "help" and
"support" forum / google group where maybe some Google staff will
extract information at good will or won't.

> But, indeed, there is mentioned that this might be a 'problem':
> <quoot>Reporting issues to Google has always been a nightmare. –
> Sébastien Jan 2 '14 at 10:18</quoot>

So nothing changed. It's a PITA and effectively one can't report a bug
and track if and when it's fixed.

  Eike

-- 
OpenPGP/GnuPG encrypted mail preferred in all private communication.
GPG key 0x6A6CD5B765632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Use LibreOffice! https://www.libreoffice.org/

[toc] | [prev] | [standalone]


Back to top | Article view | comp.apps.spreadsheets


csiph-web