poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55904] Cell getHyperlink returns null when the link is drag copied in excel
Date Wed, 18 Dec 2013 13:02:20 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=55904

Praveen <macpraveen@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from Praveen <macpraveen@gmail.com> ---
My updated solution code

public static final String RANGE_PATTERN = "(\\D+)(\\d+):(\\D+)(\\d+)";
    public static final String INPUT_PATTERN = "(\\D+)(\\d+)";
    public static final Pattern P1 = Pattern.compile(RANGE_PATTERN);
    public static final Pattern P2 = Pattern.compile(INPUT_PATTERN);


    public static boolean checkWithInRange(String range, String input) {
        Matcher m1 = P1.matcher(range);
        Matcher m2 = P2.matcher(input);
        if (m1.find() && m2.find()) {
            String prefix1 = m1.group(1);
            String num1 = m1.group(2);
            String prefix2 = m1.group(3);
            String num2 = m1.group(4);
            String inputPrefix = m2.group(1);
            String inputNum = m2.group(2);

            if (prefix1.equalsIgnoreCase(prefix2) &&
prefix2.equalsIgnoreCase(inputPrefix)) {
                int n1 = Integer.parseInt(num1);
                int n2 = Integer.parseInt(num2);
                int n3 = Integer.parseInt(inputNum);
                if (n3 >= n1 && n3 <= n2) {
                    return true;
                }
            }
        }
        return false;
    }

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message