Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

On Tue, 2011-05-17 at 18:17 +0900, matuaki wrote:


Japanese date format "YYYY年MM月DD日" is not recognized as a number on
date type on Axis format in Chart

How to reproduce the problem.

Tool->Option->Language Settings->Languages->Locale setting "Japanese"

2.Input value A1=1/1,A2=1/2,A3=1/3,A4=1/4,A5=1/5 and
3.Select A1:B5
4.Create Column Chart(used Wizard)
5.Chart area double-click and right-click on X axis
6.[Format Axis] click on context-menu
7.[Scale]tab click and "Date" select in [Type]listbox
8.[Automatic]check-box in [Maximum] is unchecked
9.[Maximum]value changes "2011年1月5日" to "2011年1月3日"
10.Open dialog box "Numbers are required. Check your input."
11.[Maximum]value changes "2011年1月5日" to "2011/1/3" and [OK] click.
12.Open dialog box "Numbers are required. Check your input." again.
13.[Maximum]value changes "2011年1月3日" to "2011/1/3" and Enter key down.
14.Chart changes.

I think that date format changes "YYYY年MM月DD日" to "YYYY/MM/DD" in
[Maximum] and [Minimum]text-box in Japanese locale.





Unsubscribe instructions: E-mail to
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.