ASF Bugzilla – Attachment 37831 Details for
Bug 65241
Slope and Intercept calc doesn't handle blank cells in range.
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
changed header doc
Intercept.java (text/x-csrc), 1.83 KB, created by
Thad Welch
on 2021-04-27 10:01:56 UTC
(
hide
)
Description:
changed header doc
Filename:
MIME Type:
Creator:
Thad Welch
Created:
2021-04-27 10:01:56 UTC
Size:
1.83 KB
patch
obsolete
>/* > * ==================================================================== > * Licensed to the Apache Software Foundation (ASF) under one or more > * contributor license agreements. See the NOTICE file distributed with > * this work for additional information regarding copyright ownership. > * The ASF licenses this file to You under the Apache License, Version 2.0 > * (the "License"); you may not use this file except in compliance with > * the License. You may obtain a copy of the License at > * > * http://www.apache.org/licenses/LICENSE-2.0 > * > * Unless required by applicable law or agreed to in writing, software > * distributed under the License is distributed on an "AS IS" BASIS, > * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. > * See the License for the specific language governing permissions and > * limitations under the License. > * ==================================================================== > */ > >package org.apache.poi.ss.formula.functions; > >import org.apache.poi.ss.formula.eval.ValueEval; >import org.apache.poi.ss.formula.functions.LinearRegressionFunction.FUNCTION; > >/** > * Implementation of Excel function INTERCEPT()<p> > * > * Calculates the SLOPE of the linear regression line using org.apache.commons.math3.stat.regression.SimpleRegression > * <b>Syntax</b>:<br> > * <b>INTERCEPT</b>(<b>arrayX</b>, <b>arrayY</b>)<p> > * > * > * @author Johan Karlsteen > * @see org.apache.commons.math3.stat.regression.SimpleRegression > */ >public final class Intercept extends Fixed2ArgFunction { > > private final LinearRegressionFunction func; > public Intercept() { > func = new LinearRegressionFunction(FUNCTION.INTERCEPT); > } > > public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, > ValueEval arg0, ValueEval arg1) { > return func.evaluate(srcRowIndex, srcColumnIndex, arg0, arg1); > } >} >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 65241
:
37809
|
37825
|
37826
|
37827
|
37828
|
37829
|
37830
| 37831