[opensuse-support] LibreOffice : Date Column Format
Dear Support , LibreOffice : Date Column Format since abt 10 days problem appears with Date Column Format. Date Column Format is set to Language English USA : MM/DD/YY For example today we have 07/28/18 in Date-Column : then if i use next cell below , in Date Column , and try to enter for August 03, 2018 , as 08/03/18 , then LO flips that to "03/08/18" nevertheless , when i check that cell-format it remains MM/DD/YY ..... something odd is happening :( thanks regards ..... -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
On 2018-07-28 13:26, ellanios82 wrote:
Dear Support ,
LibreOffice : Date Column Format
since abt 10 days problem appears with Date Column Format.
You will have to say what openSUSE and LO versions you are using. Also what locale. -- Cheers / Saludos, Carlos E. R. (from 42.3 x86_64 "Malachite" at Telcontar)
* ellanios82
Dear Support ,
LibreOffice : Date Column Format
since abt 10 days problem appears with Date Column Format.
Date Column Format is set to Language English USA : MM/DD/YY
For example today we have 07/28/18 in Date-Column :
then if i use next cell below , in Date Column , and try
to enter for August 03, 2018 , as 08/03/18 , then
LO flips that to "03/08/18"
nevertheless , when i check that cell-format it remains
MM/DD/YY
.....
something odd is happening :(
<rt-click> on top of "Date-Column", A,B,C,or ..., and select "Format cells" and choose 12/31/99 and "Default - English (USA)" clicking on the column top/header A,B,... will select the entire column and apply the format to all the cells within the column. I have found on occasion (rarely) that the column is not entirely formatted or "lost" its formatting for some reason. has not happened enough to assign a cause or be enough bother to report. -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri Registered Linux User #207535 @ http://linuxcounter.net Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
On 28/07/18 15:23, Patrick Shanahan wrote:
* ellanios82
[07-28-18 07:55]: Dear Support ,
LibreOffice : Date Column Format
since abt 10 days problem appears with Date Column Format.
Date Column Format is set to Language English USA : MM/DD/YY
For example today we have 07/28/18 in Date-Column :
then if i use next cell below , in Date Column , and try
to enter for August 03, 2018 , as 08/03/18 , then
LO flips that to "03/08/18"
nevertheless , when i check that cell-format it remains
MM/DD/YY
.....
something odd is happening :( <rt-click> on top of "Date-Column", A,B,C,or ..., and select "Format cells" and choose 12/31/99 and "Default - English (USA)"
clicking on the column top/header A,B,... will select the entire column and apply the format to all the cells within the column.
I have found on occasion (rarely) that the column is not entirely formatted or "lost" its formatting for some reason. has not happened enough to assign a cause or be enough bother to report.
- many thanks Patrick : above steps taken, & done with persistence : have used LO Calc for many years : suspect Cell Date Format has taken a 'dislike' to the early days of August !! ...... regards -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
TW: suspect Cell Date Format has taken a 'dislike' to the early days of August !! .......... workaround : delete contents of offending Date Cell. next, enter digit : 8 finally , type into cell 08/03/18 which cell then accepts , without flipping date to 03/08/18 :)) ...... regards -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
* ellanios82
TW: suspect Cell Date Format has taken a 'dislike' to the
early days of August !! ..........
workaround : delete contents of offending Date Cell.
next, enter digit : 8
finally , type into cell 08/03/18 which cell then accepts , without flipping date to 03/08/18 :))
that is somewhat contrived. was it a luck guess? :) -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri Registered Linux User #207535 @ http://linuxcounter.net Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
On 28/07/18 16:07, Patrick Shanahan wrote:
TW: suspect Cell Date Format has taken a 'dislike' to the
early days of August !! ..........
workaround : delete contents of offending Date Cell.
next, enter digit : 8
finally , type into cell 08/03/18 which cell then accepts , without flipping date to 03/08/18 :))
* ellanios82
[07-28-18 09:00]: that is somewhat contrived. was it a luck guess? :)
- yes, yes : complete luck-guess ..... regards -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
Thanks Carlos , am running Tumbleweed : libreoffice-calc-6.1.0.1-1.1.x86_64 : Locale - Greece Language English USA ....... Dear Support , LibreOffice Calc : Date Column Format since abt 10 days problem appears with Date Column Format. Date Column Format is set to Language English USA : MM/DD/YY For example today we have 07/28/18 in Date-Column : then if i use next cell below , in Date Column , and try to enter for August 03, 2018 , as 08/03/18 , then LO flips that to "03/08/18" nevertheless , when i check that cell-format it remains MM/DD/YY ..... something odd is happening :( thanks regards ..... -- To unsubscribe, e-mail: opensuse-support+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-support+owner@opensuse.org
participants (3)
-
Carlos E. R.
-
ellanios82
-
Patrick Shanahan